Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Prefilling Form with User

Topic Labels: Formulas
Solved
Jump to Solution
186 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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}