Dynamic Signature

[Johnny_Hacking]

Trying to think of the best way to structure data. We have a safety form we are creating which require attendees to sign the form. This can sometimes be 3 people and other time 20. When setting this up, do I just add 20 columns for each user to cover a meeting that holds that many attendees? or Can I make it dynamic in a way so the user can select the correct amount of signatures needed to be on the form? Just looking for some insight.

thanks,

[Grant_Stead]

The way I handle this is with two tables.
The first table is for the “meeting” safety talk, aha meeting, whatever… The second table is for the meeting attendees… Thus, you would create the meeting, then from the detail view add an attendee, select the person, or type in the name, and sign… Rinse and repeat

[Aleksi]

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so that your data makes sense.