I would like to set the initial value for the form

[Karthick_Rajave]

I would like to set the different initial value for the form based on dropdown value(Enum). I got the formula right. Ref the screenshot: image|690x387 but its not working in the app. Please someone help me on this.

[WillowMobileSys]

I believe the InitialValue is “calculated” as soon as the field is displayed and will not change based on user input afterwards. Try using Show If, to only show the field you are having trouble with once the dropdown value has been selected - Show If = ISNOTBLANK([Dropdown Column])

[Steve]

WillowMobileSystems:

I believe the InitialValue is “calculated” as soon as the field is displayed and will not change based on user input afterwards.

The initial value will be recalculated until the user interacts with it or saves the form. So if the initial value expression makes use of some other column value of the form, and that column value changes several times, the initial value itself will be recalculated several times–so long as the user doesn’t touch the computed value.

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

Its value will be recomputed as the new entry is filled in until the user explicitly assigns/overrides the value of the column. At that point, a value has been assigned and the “Initial Value” definition is no longer relevant for this entry.

[WillowMobileSys]

Hmm, Ok. Thank you for correcting me. I’m sure I had problems with this in the past which is why I suggested the “workaround”. I guess I learned my one new thing for the day. Time for a beer!

[Aleksi]

If you don’t change that field’s initial value while adding that record, it should change the value depending on the Dropdown value.