Complete view, then go to a different conditionally selected view

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.

0 4 139
4 REPLIES 4

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?

Hello

maybe this can help you

https://youtu.be/5kYAThQByTk?feature=shared

Top Labels in this Space