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 LegendI have a feeling that I cannot prove, that when the Connected Sync Table has a key field which is different from the refresh key, there can be some buggy behavior.
My guess is that if you put in a ticket for this to QuickBase they will come back with some kind of known bug number and perhaps no timeframe to correct.
My guess is that if you put in a ticket for this to QuickBase they will come back with some kind of known bug number and perhaps no timeframe to correct.
In that case you may need to resort to some kind of Plan B Safety net. If you include in the sink table and mirror Field of the project number i.e. create a formula equal to the project number in table LA and sink that across, I am quite sure that the project number from the mirror Field will come across correctly. That would at least allow you to detect this problem situation.
If your situation is such that you actually have no data entry in table 2 then you could change the refresh method to add records but do not delete. Then you can manually delete all the records and then turn the Sync on normally again and refresh her table.
But if your table B has additional manual data entry field plan that is not going to work.
I think your next step actually is to put in a support ticket and see if they come back and say that it is a known bug. And then based on that response decide on what kind of safety net and work around options there are.
------------------------------
Mark Shnier (YQC)
markshnier2@gmail.com
------------------------------
MarkShnier__YouQrew 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
------------------------------- 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
------------------------------
