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.
Iโm having a tough time following what your goal is. Could you try explaining your goal in plain language?
The best way to describe it is that I am in a selected row of the PermitList table, when clicking on an action I would like to bring up the a new entry form for the MeterInspections table and have the many-to-many relation between these two tables preset to the new MeterInspections UniqueId and the PermitList Id to the row from which I selected the action.
Using the inline โAddโ action under PermitList Detail for โMeter Inspectionsโ sort of accomplishes this but I would like to do this in a single step if possible.
If you look at images 4 and 5 it is the MeterInspection form and since I chose new MeterInspection under the inline entry the MeterInspection form already has the reference of the PermitList set based on the PermitList record that I initiated the inline โAddโ functionality. Hopefully this makes more sense. Ultimately I want that inline โAddโ to skip over everything inbetween and just open the MeterInspections form with the relation already set based on the PermitList record that I had selected.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |