Referencing and actions

Hi all, I am having some issue with my app.

Is it possible to control an action based on another tables column? For example;

I want to show an action that links the user to another form, but I only want to display that action if the chosen Delivery Schedule for that record has been approved.

Delivery Schedule and approval status are columns in another Tbl called โ€œDelivery Schedulesโ€.

2X_5_548ef2e595b2a5be7c2291d13d4112325d0b5d51.png

The Order Details Table that holds all Request info has a Delivery Schedule column (Ref Column).

How could I control the action based on the selected delivery schedule per request being approved? i.e. if the Delivery Schedule for each inidivual record is approved the action will show?

To view the requests for each Location and Schedule you select the Block, then your Schedule and the requests are grouped by a Sub-Location.

It should be noted that there is only one type of Request this process is applicable to.

** Also, is it possible to create an inline view such as Related Order Details using a Table Slice? I have tried to do this but it displays as a gallery inline view which I cannot change?

All suggestions appreciated

0 4 510
4 REPLIES 4
Top Labels in this Space