Help

Prefilling Form with User

Topic Labels: Formulas
Solved
Jump to Solution
1903 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Greg_Culley
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
KVachon
6 - Interface Innovator
6 - Interface Innovator

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}

See Solution in Thread

2 Replies 2

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
6 - Interface Innovator
6 - Interface Innovator

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}