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
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.
yes I only want the Username on the create not the edits. I want it to hold the name of the author
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.
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.
Hi,
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |