Prefilling Form with User

[Greg_Culley]

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.

[kuovonne]

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.

[KVachon · Accepted solution]

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}