9 votes1 comment · I would like to see... » improve existing feature · Flag idea as inappropriate… · Admin →
I second this, as I have run into similar issues. The problem it would seem, come with deleting records that have more than one link to a parent record. In other words, although it is possible to use app scripts currently to delete child records that are only linked to the parent record table the app script is run from, I would love to see the ability to delete the child records regardless of their other relationships.
Or at least a short tutorial on how this can be achieved using app scripts!
If adding an array field enables line item support in Zapier, then I am onboard with this as well
I have found a potential work around using FLOWS. This may not apply to every situation where a many-to-many relationship is needed but it can be used to some extent.
Step 1: Use an add or view task on parent table.
Step 2: Use an add task to create a child. Set a variable to populate the link to parent field.
Step 3: Perform a View using Parent Record ID as variable lookup on the Parent Table.
Step 4: Perform an Edit Task on Parent Table after the view task. This will automatically open the Form related to the Parent Record. Set Variable to populate Link to Parent Table (original child record)
Thank you for the reply. Is it possible using the python API to reverse geocode the Latitude and Longitude and then return the address to TrackVia?
Thank you in advance for your help,