Unable to use USEREMAIL() and NOW() in Prototype Application

[Mohit_Kumar_Sin]

Hey there,

I am trying to capture the Last Modified By and Last Modified At by using USEREMAIL() and NOW() in the app formula. And using an Actual Column in the spreadsheet, not any Virtual Column. But when any user makes any changes to the record, it’s neither capturing the USEREMAIL() nor the timestamp.

Currently, the Application is not deployed. I am using the application with small no. of users to test the application functionality.

Can you please help me figure out the issue here.

Thanks

[1minManager]

Not sure if this is how it works…

But go into the column settings and try turning "Reset on edit?" on

Simon@1minManager.com

[Aleksi]

Your formula in app formula option should do that exactly. When you open that record, it will update the USEREMAIL and Timestamp. Have you specified anything else in those column’s definitions?

[Mohit_Kumar_Sin]

No. It just have USEREMAIL() and NOW() as app formula in respective columns.

[Mohit_Kumar_Sin]

I had tried this earlier in the same way and was working fine. But now it’s not capturing any values.

[Steve]

Are the columns filled with the desired values in the form, prior to saving?

[Mohit_Kumar_Sin]

Hey @Steve These are formula fields. It should evaluate the formula and put the respective value. There are no manual inputs in these fields.

[Steve]

If you display the Last Modified By and Last Modified At columns in the form, are the column values pre-filled with the calculated values, as expected? Essentially, are the computed values present in the form at submission time?

[Aleksi]

@Mohit_Kumar_Singh May I ask what is your account ID, app name, table and column name if I check your app?

[Mohit_Kumar_Sin]

@Aleksi Shared details with you in DM.

[Aleksi]

The reason was the initial value field. The app had both app formula and inital value.

[Mohit_Kumar_Sin]

I added the initial value formula to see whether it’s capturing any value when the record is edited for the 1st time. but no success there as well. Tried after removing the initial formula, but then also nothing is getting captured.

[Aleksi]

Another reason was a slice. Columns were missing from that slice as well.