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?
Question
What should my primary field be when creating an anonymous survey?
+2
+9For 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.
+4if 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.
+6I’ve used the Autonumber field type when there isn’t a natural Primary field
+28As 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.