Because I can’t delete or hide a primary field, I’m not sure what it should be in an anonymous survey because I don’t want it to be name, email address, etc. Any thoughts?
For any data that is coming in arbitrarily -- like a survey -- use either a natural key it already has or make a surrogate key somehow.
The easiest way to do that would be to change the column type to autonumber -- Airtable will just make up IDs. Actually logical for survey responses as they probably should have no uniquely identifying information. You could make it a formula based on date created too, but I that could have collisions if you happen to get two at the same time.
if you are using a form to send out the survey, you don’t need to show the primary field to the receivers.
on the data end, perhaps an autonumber field would work for your needs.
I’ve used the Autonumber field type when there isn’t a natural Primary field
As mentioned above, you don’t really need to have the primary field on the form. Either way, you might want to convert the primary field into a formula and have the formula be: RECORD_ID()
Hope this helps!
Mike, Consultant @ Automatic Nation
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.