INPUT() function Default Value not working

AppSheet Tips & Tricks
13

@Adam-google

#MeToo

I also prefer the existing behavior.

With the 3 action set, we can give the initial value for input as a workaround we have.

First we place a physical column apart from column which is a target column for input action (let me call this column as TEMP column. Let me assume to pass the TODAY date for the target column input. (while the target column is null to get start)

Grouped Actions

  1. Set value of TEMP column to today().

  2. Open Input Form against TEMP Column.

  3. Pass the value from TEMP column to Target Column

    This action is only available where the target column stays NULL.

    Then create another simple INPUT action against target column whose action is only available where the target column is NOT null.

    I do have this workaround in our various apps.

@Steve

1 Like