How to navigate to a new view from within a Form view

AppSheet AppSheet Q&A
1

I have a table called Users containing a number of columns. I also have a table called PayRates, containing User_ID, rate and effectiveDate columns. I have set up a view to edit the values in the table called PayRatesTable.

I have a Users_Form view which I use to edit the columns for a User. From within that view, I want to be able to easily navigate to the PayRatesTable view for that User.

The closest I have got is to add a Virtual Column of type Show, category URL and then added HYPERLINK(TEXT(LINKTOVIEW(“PayRatesTable”)), “Tap here”). However, this takes me to a new tab in the browser. The other solutions that I have found only work in a Detail view, and not in a Form view.

Does anyone have any suggestions please?

2

In the PayRates table, in the User_ID, you could enable Is a part of? If you then include the Related PayRates column in the Users form, the app user will be able to add and edit (but not delete) PayRates entries for the User.

2 Likes
3

Thanks for the suggestion. That seems to work. Any suggestions for how the user can delete an entry?

1 Like
4

They cannot within a form view, but they could from the Related PayRates inline view in the Users detail view. You could add a column to PayRates called Delete (e.g.) of type Yes/No that the user could set to Y, then have a bot that deletes the entry if Delete is Y.

1 Like
5

Many thanks for your help.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.