© 2016 Assisi Software Corp

  • LinkedIn - Black Circle
  • YouTube - Black Circle
Dec 30, 2016

Selecting Graded Cruises Only

1 comment

Rich, I am trying to run a query on cruises which have an actual quality calls on a cruise. The challenge is all stands have a grade weather we measured in field or not. How could I go about doing this only to isolate the stand which had an actual field call on logs. Let me know if you have time to discuss or respond to my email. Hope all is well. Thanks Eric

Dec 30, 2016

Sounds like you are trying to find all the cruises with field called logs as opposed to cruises with only total heights called. The Logs table should have everything you need since it stores all the field called logs and grades. If there is a record in the Logs table, then there was a log called in the field. Run a query like the following: SELECT Stand FROM Logs WHERE NOT Grade IS NULL GROUP BY Stand Rich

New Posts
  • Wanted to give a quick update on Assisi Cruiser, our upcoming data collector. Our prototype in PowerApps is working OK, but PowerApps has too many restrictions like meant to be online and can only share apps with members of the same computer domain. So now I am also prototyping in Xamarin: the cross platform (iOS, Android & Windows) tool of choice for most serious developers. It's going well and I should have something for others to test soon. Send me a note if you are interested in beta testing! Rich
  • Is is possible to change the BAF in the middle of a cruise?
  • This afternoon we are starting our seasonal inventory cruising program. Radial growth measurement. I would like a 5 year growth measurement. You have a field in Assisi for this, but I don’t see one on the spreadsheet. Just add it before the first segment call?