Hi All,
I'm writing a quoting app. I need to collect basic information that is common across multiple product types, including the product type itself. Then, the user should be directed to a view that is appropriate for their selected product type.
The product type detail view needs to conditionally display fields based on the user's input in the first view. I'm including a generated quote number in the basic info view, and I'm assuming that this quote number needs to be written to the second view table as a foreign key.
I'm very much a newbie to AppSheet, and I welcome any and all suggestions on how I can accomplish this task.
Hello sir.
In this case you could use LINKTOFILTEREDVIEW() combined with AND() for multiple conditions.
LINKTOFILTEREDVIEW("View_name",AND([product] = [_Thisrow].[Product], [Size] = [_thisrow].[Size]))
It has to be an action "Go to another view within this app" and every time the action is executed the user will be taken to this filtered view
@peterson
Thank you for the answer.
How do I branch to different views depending on a field's value? can I use a SWITCH?
Well, that depends, you can maybe use IFS() as it follows:
IFS( AND(condition 1, condition 2 condition 3), LINKTOVIEW(View _ A)
,
AND(condition 4, condition 5 condition 6), LINKTOVIEW(View _ B)
)
Something like that?
User | Count |
---|---|
19 | |
13 | |
8 | |
3 | |
2 |