Connected table Key field is not updating
Hi All, I have two applications ( App1 and App 2) , One of the table from app 1(Projects ) is connected to app2 . The refresh key is the record id and key of that table to other table in ap...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend Another suggestion is to go through the steps I suggested to change the sink to add records but do not delete, then delete all the records and then put it back to sync exactly.
It is possible that since you have already made the key field change in table B that the Sync will work properly this time when you change the Project No.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
Thanks Mark for your quick response.
I did raise a ticket with Quickbase support team , they replied to me saying this is the usual behaviour.
And one thing which i cannot understand is that they said if there is change in key field then a new row will be created in connected table which is not happening currently.
And in my connected table there are around 10 formula field and relationship from and to other tables but there are no manual entries field , is it advisable to delete all records and refresh again.
Kindly advise.
Regards
Mohamed Hannan
------------------------------
Mohamed Hannan Sait
------------------------------
I did raise a ticket with Quickbase support team , they replied to me saying this is the usual behaviour.
And one thing which i cannot understand is that they said if there is change in key field then a new row will be created in connected table which is not happening currently.
And in my connected table there are around 10 formula field and relationship from and to other tables but there are no manual entries field , is it advisable to delete all records and refresh again.
Kindly advise.
Regards
Mohamed Hannan
------------------------------
Mohamed Hannan Sait
------------------------------
- MarkShnier__YouDo you have the set up for the Connected Sync table to match the source table exactly or to add new records but not delete?
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------- Got it , I have set it as " Match the source table exactly"
------------------------------
Mohamed Hannan Sait
------------------------------- MarkShnier__YouMy suggestion as something worth trying Is to change the Sync set up to add records but not delete. This is in fact will let you delete all the records in your Connected Sync table using normal methods. Then change the setting back to match exactly and refresh the table. The records will come back and everything will match up perfectly.
Then once again do a test of a change of the Project No and see if it behaves any better.
I don't really understand why Support would say that that would be the expected behavior. It seems impossible that the expected behavior is to create a new role in your Connected table because that would duplicate the key field.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------