I have a Safety form.
I want all personnel present to give their [Name] and [Signature]
Is adding x number of these columns to the spreadsheet and then adding a SHOW IF condition the only way?
And if it is the only way.......how do I do it faster than copy/pasting then editing a formula into each asking it to show if Row x is filled?......cause its quite slow
No, that's not the only way, in fact that's the worst way. You should have a record for each pair of name and signature.
I suggest 2 tables; a safety parent table, and a safety_personnel child table. A one-to-many relationship.
https://help.appsheet.com/en/articles/961426-references-between-tables
Thanks for the response.
Hmm, I need them to sign it (fresh) each day. Yes, some of the personnel can come from a referenced list, but there are also new personnel each day, and I really don't want to onboard them to a database.
So I just need a single form where user can input multiple Names+Signatures.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |