Initial value

AppSheet AppSheet Q&A
1

Hi,

I have the expressions in initial value and in formula. I don’t have any error notifications.

HguillenA_0-1699018949295.png
HguillenA_0-1699018949295.png923×144 13 KB

Then, when I log in to the user settings and fill out the form, only the data from the columns with expressions in the formula are being recorded. What could be happening?

Thanks in advance for the help.

2

The app formula is calcualted if you open the form view.. either for the first time or later. The initial value is calculated only when you create a new record (if the “Reset on edit” option is set as OFF).

3

Thank you AleksiAlkio for your time. I understand, but it’s not yielding results. If I define the expression in the formula, it displays the staff and timestamp. However, if I use the same expression in the initial value, the result is blank

HguillenA_0-1699032440881.png
HguillenA_0-1699032440881.png404×123 6.22 KB

4

And you have tested this with a new record?

5

Yes, I did

HguillenA_0-1699236631023.png

6

What happens if you try these two formulas with your initial value?
[_THISUSER].[User Name] or
ANY(_Per User Settings[User Name])

7

Thank you,

I used [_THISUSER].[User Name] and it works