If all users have a record in the base, is there a way to prefill the user field on a form with the user who is signed in when they access the form URL? Not having luck creating a prefill formula that accomplishes this.
Solved
Prefilling Form with User
Best answer by KVachon
One option you have, dependent on your use case, is to set up a button field that opens a URL and links to the form, and references a user field in your base. It could be a manually populated field, collaborator/user, selected field, created by, or even modified by.
Example:
"[insert your form URL here]?prefill_UserIdField="&{Last Modified By}
+29Welcome to the Airtable community!
Formula fields do not have access to the current logged in user. You would have to get the user in the record data in order to have a formula be able to prefill that value.
+11One option you have, dependent on your use case, is to set up a button field that opens a URL and links to the form, and references a user field in your base. It could be a manually populated field, collaborator/user, selected field, created by, or even modified by.
Example:
"[insert your form URL here]?prefill_UserIdField="&{Last Modified By}
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.