Updating address Field From Other Table

Question

I have a stores table related to a parent (shopping centres) where we have an address field. When creating a new store, is there a way to copy the contents of parent table to the address field in stores? I understand I can look up the contents but issue is that the adress in the parent table may or may not be the same as we want in the stores table. But being able to copy the address in the child will minimise our typing effiort where address is more or less the same.&nbsp;

davidhawe · Answer

In my opinion, this is an excellent candidate for the new feature Quick Base Actions. Similar to alerts, you can set them up to only fire when a record is added, you tell them what table to update, and map the source table fields to the target table fields.

http://www.quickbase.com/quickbase-blog/how-to-boost-your-app-design-using-quickbase-actions-part-1

quickbasecoachd · Answer

Wait, in this case I suggest regular old form r.ules.

Bring down the address field components as look up fields and have a form rule that says basically when the address is blank then change the address field to the value of the lookup fields.

The reason for this is that actions only fire when the record is save and in most cases they probably want the store address to be the same as the center but in some cases they will know they have to override it or perhaps just add a Suite number.

arshadkhwaja · Answer

Thanks. &nbsp;I wrote this request after trying with QB Actions, There seems to be a limitation that you can update a field within from the parent table. &nbsp;I tried but the &nbsp;report link option is not there to select.&nbsp;

quickbasecoachd · Answer

In fact you can edit the Oarent with a Kirk Trachy Trick. You make a report link field based in the Record ID field and create it on the right to the same field. Ie search to set he app, and the fields to find the same fields.

If stores are being added via Grid Edit , then actions would be your best bet. But if they are being added on Forms, then I would suggest using form rules.

arshadkhwaja · Answer

Thanks Mark. &nbsp;Tried the form option by looking up 'address' field not its components. &nbsp;The rule I creeated is not able to find a "compatible" field.&nbsp;

Forum Discussion

Updating address Field From Other Table

Related Content

Snapshot Fields

User field not updating

URL Syntax using updated addresses?

Updating $$ amounts

Consolidate Field Types