I have a Work Ticket table with a column for work groups and slices for each group. When a ticket status is updated to complete on a WT Log I can update the main Work Ticket table status but want to have the next workflow action go to the slice view for the specific users’ work group. I don’t see how I can use and IF expression to do this. Or is there another way ?
To be clear, a workflow cannot navigate the user anywhere: a workflow is performed on AppSheet servers, not on the user’s device, and so has no opportunity to navigate the user. An action, though (one not being performed within a workflow), can navigate the user to another view. So what you need is an action attached to a button the user presses, or attached to a form the user completes. Either of those can navigate.
To navigate the user to a particular view within the app, use an action of type App: got to another view within this app, with a Target expression that uses a LINKTO…() function to indicate the desired view. You may use an IF() expression within the Target expression to choose the desired view:
IF( ("complete" = [status]), LINKTOVIEW( LOOKUP( USEREMAIL(), "Users", "Email", "Workgroup View" ) ), LINKTOVIEW("Work Ticket Table") )
Forgot to mention I had an action to another view as part of a workflow already. Just didn’t know how to write an IF statement that would get the results I was after and where to put it. I get your instructions perfectly.