3 forms, same data source

Hey all,

I have been fighting this one way too long and in typical fashion, I am fully expecting a very simple solution.

I have the following tables:
Rentals (with a DVD ID column)
This allows me to check out a DVD from the collection.

Here is what I want. I have an action that opens a Rentals Form that only shows the DVD, checked out by, and checked out date. This is in place and working great (see image).

To check the DVD back into the collection, I navigate to my slice called DVDs Out and open the detail view (see image).

I want to open the form to edit it, but only show the DVD and checked in fields instead.
I also need the edit button to open the entire form to show all fields.

How do I tell the app which form to open on 1 data source?

You’ll need to create your own “edit” action. The action type would be “navigate to another view”, then you’ll specify a LINKTOROW() expression for it. You hide/show the appropriate fields in various ways, either by creating another slice, or by defining show_if expressions, perhaps utilizing CONTEXT(“View”).

Can you run with that, or do you need more info?

1 Like

That did it. I didnt even need to do a show if!
I set two virtual columns, one for a edit view and one for a check in view. Then I set actions to those VCs.
So, I now have a manually added edit action that says go to another view in this app with a formula of LINKTOVIEW([Edit all View]) and an action to check in the DVD with a formula of LINKTOVIEW([Edit Check in View])

Thank you! And as I suspected, super easy!