Solved: Initial Value based on Form - Page 2

Michael_at_Graz · 01-12-2023 07:04 AM

Hello Appsheet Community!

I have the following question:

I have one table "Aufträge" and created 2 slices for 2 different forms and views ( "Vorbereitet" and "Erfasst" ( these are the names of the Views and Forms)).

So now, i want to set an initial value for the column "Status" based on the form i choose.

For better understanding:

If i open the form "Vorbereitet" the column Status should be set to "Vorbereitet" and if i open the Form "Erfasst" the column Status should be set to "Erfasst".

It would be very great to get some help for finding a solution.

Many thanks in advance and nice greets from Austria

Suvrutt_Gurjar

Please use CONTEXT("View") function based expression in the initial value

IFS(CONTEXT("View")=""Vorbereitet"", "Vorbereitet",
CONTEXT("View")="Erfasst", "Erfasst"
)

relevant help article: CONTEXT() - AppSheet Help

Please ensure you name the form view names properly by confirming view names that reflect in the app editor as shown below

View solution in original post