Field change in connected table triggers field change in local table's corresponding record - possible?

Question

I have an app that uses connected tables and regular tables. My records are "products" in this situation.

When work is done on a product, my vendor updates the status for that record/product to "complete." I have a table within my own app that more or less mirrors the vendor's table. The two tables have fields with matching values, which I'm hoping I can use to leverage a relationship.

What I want to achieve is: when the vendor updates a product's status to "complete" in the connected app, I want the corresponding record in my app to update to "complete." Ideally, this would be a text value and not a checkbox, but I'm open to any/all thoughts on the best way to approach this.

quickbasecoachd · Answer

If the Key field of your table, for example the Item number or even record ID# is also in the connected table, you can make a relationship where 1 of your records is related to Many connected table records.

Then just make a summary count of the # of Completed connected records.

archiveuser · Answer

Ack. Just realized that the field in my table that I wanted to use as a key field is a formula.

I had to concatenate a couple of other fields to get a unique match the the corresponding items in the connected table.

Is there any way around this key field/formula field issue?

quickbasecoachd · Answer

Actually there is. &nbsp;Almost nobody knows this. &nbsp;You can enter the API call to change the key field of your table to a formula field. &nbsp;It is not really documented and to be truthful, I have not used this myself. &nbsp;I heard about this at EMPOWER and have yet to have to opportunity to et answers from QuickBase as to how safe it is to use. &nbsp;Perhaps Quick Base&nbsp;support can tell you.The API call is herehttps://help.quickbase.com/api-guide/index.html#setkeyfield.htmlSo you would go to the table in question and type this after temporarily disabling the need for Application Tokens.I would suggest testing on a copy of your app first, but that could be difficult since you have a connected table.https://target_domain/db/target_dbid?a=API_SetKeyField&amp;fid=7

archiveuser · Answer

Wow. This is great info. I will clone my app, test,  and report my results. Thanks.

quickbasecoachd · Answer

Yes, Kirk Trachy mentioned it at EMPOWER at an informal session and we were astonished. &nbsp;I appreciate the testing.

Forum Discussion

Field change in connected table triggers field change in local table's corresponding record - possible?

Related Content

Connected App same realm

Filter records based on table connection

Connected table not updating when record is changed in the connected database

Intacct Connected Tables: Connection Settings Need to be Updated by February 28, 2025

Pipelines - Connected Table Refresh