Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 28, 2022 12:44 PM
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! Go to Solution.
Oct 28, 2022 05:04 PM
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}
Oct 28, 2022 01:22 PM
Welcome 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.
Oct 28, 2022 05:04 PM
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}