I need a field that is populated with the person who submitted a form

Is there a createdby? or author field? for each record?

See “Limiting Users to Their Own Data” in this article https://help.appsheet.com/en/articles/1128148-limiting-users-to-their-own-data

1 Like

Hi Laurie,
there is no specific field that lets you have that. However, you can add a column in your spreadsheet to record who makes a change. Then you can set an initial value for that column with “USEREMAIL()”. Then whenever someone creates a new record, the field will be auto-populated with that user’s email.
Note that the app must require people to sign-in for that function to work.

1 Like

yes I only want the Username on the create not the edits. I want it to hold the name of the author

The challenge is that some datasource provider don’t return username value when we invoke the function. Useremail has proven to be more reliable function instead if that is an option for you.

1 Like

As Thierry was saying, the user email will be more reliable.

If you use the USEREMAIL() in ‘INITIAL VALUE’ field for a column, it’ll only add that when you create it. When another user edits that record, the email won’t be modified unless they do it on purpose.

However, if you use USEREMAIL() in the FORMULA field for a column, it’ll be updated everytime a user creates or edits the record. That’s not what you want.

1 Like

This workaround may be a little complex or cumbersome to implement depending on how your app and users work but…

You can capture the users name once, such as at login “welcome, enter your name”.
Then set this into a new table with a unique ‘login instance id’
Now as your user moves through your app, you can carry that id as forward as a variable set as the default value on new records generated.
In context this looks like after they login in, the navigation to the next screen includes to write the login id to a new potential record.

I don’t know exactly how your app works so I can’t give any further specifics.
Hope it helps
Edit: you’d make the ‘enter your name’ as required, then compare the email for better accuracy.