Forum Discussion
MCFNeil
8 years agoQrew Captain
Maybe a workaround to make it automatic still, is to use a QB Action to take copy the proper values.
Have the Zap write the values to regular text fields, and then have the action copy the values into the address sub-fields..
Just an idea to try.
Have the Zap write the values to regular text fields, and then have the action copy the values into the address sub-fields..
Just an idea to try.
QuickBaseCoachD
8 years agoQrew Captain
An ACTION can in fact edit the record its triggered by. There is a "cheat" for this. When it says edit related records, in fact it means edit the records defined by this report link field.
So the trick is to make a report link field which maps the [Record ID#] of the record you are on to the same app, then same field [Record ID#]. Obviously there can only be one record with the same record id that you are on.
Be careful in setting up the ACTION that you do not create a loop as an ACTION editing a record can trigger an ACTION to do that same edit again if you are not careful. It will error out after 10 loops, but still have set up the conditions so that it does not loop.
So the trick is to make a report link field which maps the [Record ID#] of the record you are on to the same app, then same field [Record ID#]. Obviously there can only be one record with the same record id that you are on.
Be careful in setting up the ACTION that you do not create a loop as an ACTION editing a record can trigger an ACTION to do that same edit again if you are not careful. It will error out after 10 loops, but still have set up the conditions so that it does not loop.