How do you conditionally add a column?

[Driller]

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

[Marc_Dillon]

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

[Driller]

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.