Initial Value issue

AppSheet AppSheet Q&A
,
1

Hi there,

I have a question to Initial Value.

  1. I have a user setting “Probestelle” defined to enter a fixed date.
  2. I have a table with a field “Datum” with data type. For this field I have defined an initial value formula: IF( ISBLANK([_THISUSER].[Probetag]), TODAY(), [_THISUSER].[Probetag] )

Intention is that the user can fix a date (different from today) which shall be used if new records for this table are being created. No additional required_if or editable_if are defined for this date field.

  1. I have a view which groups the available records by the data field “Datum”.

Now assume I have entered a fixed value other than today in the user setting.

If I create from the view above a new record the expected date value is used in the Form View.

I I select first another date from the grouping and create then a new record, always the selected date is being taken. The initial value is simply overwritten.

I am using appsheet since years, but this behaviour is new for me. For me this seems to be wrong. I would have expected that initial value always has priority.

What do you think? Anyone having the same issue?

2

When adding from a grouping, AppSheet tries to preserve the chosen grouping values in the new row, overriding the defaults in column configurations. There is no way to avoid this in grouped views using the built-in Add action. You could try replacing the built-in action with your own, but that would also face some challenges.

3

Thanks Steve,

did this behaviour change over years or is this unchanged? I wonder that I never had troubles before. Currently I face the first time that user was in a grouped list, added a record and complains that the new entry is lost.

Nevertheless thanks for the hint replacing the system action by something own. Will do that.

Best Christoph

4

The behavior I described is the only I ever recall within nested grouped views.

Note that if your view has only one level of grouping, such that all groups are shown expanded in the same view, the behavior I described does not occur.