What approach to use on an app I am working o...

(Marius Scholtz) #1

What approach to use on an app I am working on for logging shark / whale sightings. Every trip has a standard heading including things like trip #, vessel name, skipper name start and end time.

Then each sighting becomes a line item under this heading including things like lat/long, specie code, count, comments and photos.

My question is what approach to take for compiling a PDF at the end of the trip with the heading info at the top and each sighting as a line item below in rows?

(Emmanuel Benjamin) #2

It should be easy I reckon. Could you explain the codes in the screen shot attached?

(Aleksi Alkio) #3

Create a Google Doc as a template. Create the doc with different tables and then call all related records with Start… End expression.

(Praveen Seshadri (AppSheet)) #4

@Marius_Scholtz, specifically for generating a report, please look at the topic of “Scheduled Workflows” (in the app editor, these are called Reports) help.appsheet.com - BEHAVIOR | AppSheet Help Center and specifically for you, I think you need this sub-article

https://help.appsheet.com/behavior/workflow-sending-email/email-scheduled-event-templates-without-for-rows BEHAVIOR | AppSheet Help Center help.appsheet.com

(Marius Scholtz) #5

@Emmanuel_Benjamin Those codes will be long and lat that I will simply do with Long Lat columns type.

(Marius Scholtz) #6

@Aleksi_Alkio this is how I started structuring it. I created a trip table that holds all header info and a sighting table for the line item records for each sighting. Then I have each sighting references the trip. Am I on the right track? Can you give E me more help on the use of the Start End expression?

Also I have the Sighting reference the Trip but because there are daily trips the list of trips will get very long and confusing soon. I tried for the reference to only show trips for that day by using the Show_if field with…

[Date] = “TODAY()”

but it does not work.

(Aleksi Alkio) #7

You are on the right track.

When the trip data is already there and you open the detail view, you will see all Sightings on the line item view. When the user adds a new line item, the correct trip is already choosen and no need to search from the list. You can also create an action button for doing the same thing if needed.