Forum Discussion
As soon as you make the parent table related to itself that will be a looping relationship so the Snapchot field will not solve the loop.
One solution could be to have a connected sync table of just the template parent records. all you would need is a title for the record like Project Nam and the Record ID of the original parent table. That record ID will come across as [Record ID#2], but so you don't confuse yourself rename that field to be called [Record ID# of Project Template Record]
Then make a relationship where the project template connected sync table has many project records and you will choose which template do you want to use for the copy Parent Child parent child. The lookup of [Record ID# of Project Template Record] what you would use in the Java script copy parent child formula field.}
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Loran Prince
Prince Finishing Inc
Edmonton's Premier Finishing Company
780-700-9057
8420 34A ave
Edmonton AB T6K 0C2
greatservice@princefinishing.com
- MarkShnier__You2 months agoQrew Legend
I'm not understanding what you did. You should just add a table to your existing app, not a new app.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- LoranPrince2 months agoQrew MemberOk, I created a table using the option of connected data in the same app and it takes me to the same place with the same error message
Still I am doing something not right! What is it
Loran Prince
Prince Finishing Inc
Edmonton's Premier Finishing Company
780-700-9057
8420 34A ave
Edmonton AB T6K 0C2
greatservice@princefinishing.com
- MarkShnier__You2 months agoQrew Legend
I am not familiar with that error message so you may need to go to Quickbase support to get them to help you wth that. The usual way of setting up a connect a table from within QuickBase would be to click on your name at the top right corner and then My Preferences, ad then create or assign a user token to that app, and then you use that Token when creating the Connection for the Sync table.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------