Updating address Field From Other Table

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

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.

Thanks.  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.  I tried but the  report link option is not there to select. 

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.

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

No Problem,


While firm rules don't work on Address field Types, you can lookup the individual components of the Address fields. They are listed in the Adress field itself.


Then have a form rule trigger when Centre: Address Street 1 is blank to fill in that field and more Actions in the form rule to also fill in the other components like street2 etc down to postal code.

Thanks.  but for the sake of testing the 'blankness' of the addresss fields in stores, I hope I can use the address field as the condition? 

I tried it with and without firing the rule but does not update new store with the centre address. 

I suggest changing it to firing all the time, not just on save.  (I made that change just now and it worked)

Thanks. Yes it is working. Appreciae.