Set Initial Values in a form for 'Is part of' in Bridge Table

[Markus_Malessa]

I have a map of Meters with a one-to-many relation to Meter Inspections and the Meter Inspections also have a many-to-many relation to Permits. From the map I can log an inspection for a meter and the meter inspection form already has the the meter relation set to the meter that I initiated the action from. The meter also has a dereference to the keys of the Permits. Now I am trying to set the meter inspection form reference to permits based on the the Meter[Permit_keys] so that I can add the many to many reference all at the same time prior to saving the new inspection entry.

I have attempted this via my custom action where I did the following:

Action is part of my meter table LINKTOFORM("LaramieCoMeterInspections_Form", "MeterInformation_fk", [_THISROW], "Related Permits", [_THISROW].[Permit_Keys])

The first part sets the meter relation to the inspection, the second part was supposed to set the (list) of values for the permits to this inspection. Unfortunately this does not work and I was hoping someone might have a solution. I have already set up an action on the meter inspection itself that executes a series of actions adding these relationships using ‘add a row to another table’ multiple times, but I would rather preset this relationship if possible. Any ideas?

[Michuli]

any ideas on this?

[Markus_Malessa]

Yes and No. This is still not 'naturally integrated'. I implemented a work around that consists of an additional 'actual' column in the relevant tables of just type VARCHAR in the MySQL DB and then set it as type EnumList in Appsheet with subtype of REF. Then I still had to implement several actions that takes the values from the EnumList column and actually writes them to the Bridge Table that is just my Key Value table. Hope that makes sense, but this is another one of those instances where Appsheet lacks some natural integration.