Agricultural field/crop inspections and reports
With this app, an agricultural inspector can mark a specific GPS location, take up to two images, and add observations associated with the pictures and location, and suggest a course of action. The app shows a map, a form to collect data, and a table displaying all locations and pictures. A report on the crop’s condition may be sent to a designated recipient such as the farm owner, a regulatory authority, and a service provider.
Also see: tablet mode & fullscreen mode
How we built this app
–The app uses a Signature column to allow the inspector to sign each inspection. –Tabbed Forms avoid having to scroll down through a long form. It also makes it easy to jump to different sections of the form. –GPS Location. There is a column in the spreadsheet called "Geolocation". This lets AppSheet automatically identify the column as a location data column and capture the GPS location for every row added when GPS location is available. This has an initial value of HERE(). –Slices. See Data >Slices. The app has a slice to filter out inspections requiring follow-ups using the formula [Followup Required Y/N]="Yes". –Workflow. See Behavior > Workflow. The app has a workflow which sends an email to the contact person at the farm when a new inspection is done. –Reports. See Behaviour > Reports. A report can be scheduled to be sent out at various time intervals to a designated recipient. This can be set up to contain the whole table of inspections or just individual rows depending on your requirements. –Formatting. UX >Format Rules are applied to the map pins using the location column and icons. The four farms are formatted in different colors. –Map View. The map view allows you to inspect all the data points in the app and it even lets you add a new record by placing a pin on the map. You need to be close enough to the location for the "+" and pin buttons to become available.
This is a preview of the data sets used in the app.
This is a high-level model of both the data entities and the UI elements in the app.