I have the following scenario:
A table of PermitList with a many-to-many relation to MeterInspections via a bridge table called LaramieCoMeterInspections_Has_PermitList. In the detail view of PermitList I have a Derefence column with formula
REF_ROWS("LaramieCoMeterInspections_Has_PermitList", "PermitList_fk"). From this inline view I have a ‘Add’ button when clicked brings me to the relation view where the value of PermitList_fk is set to the id of the current PermitList row and the MeterInspection_fk field I can choose ‘New’ or an existing MeterInspection row. If choosing new then the MeterInspection new row will have the PermitList preset and I can continue entering the information for the MeterInspection.
I would like to use a custom action under PermitList that will accomplish this ‘step?’ process and figured I could get this accomplished via ‘go to another view within this app’ and using the following navigation
LINKTOFORM("LaramieCoMeterInspections_Form", [Related LaramieCoMeterInspections_Has_PermitLists][PermitList_fk], [_THISROW]). Unfortunately this does not seem to work. Ideally I would like this kind of action both as the prominent action for a PermitList row but also would like this type of action to replace the default ‘Add’ inline action under the Dereference to MeterInspections.
Can this be accomplished via a sequence of actions possibly or is there some other way to set up the Linktoform navigation to get this accomplished? @Steve Hoping maybe you have some insight on this since you seem very knowledgeable on Appsheet.