Forum Discussion
LoranPrince
2 years agoQrew Member
Hey good morning Mark, Thanks so much for your help. I know you are the most knowledgeable guy there!!!!
I used to come to your big events when you had them live.
The button works, however. You are correct about the templates being on the same table.
The code they way I set it up does copy the child records and the grandchild records.
the code is
"javascript:void(copyMasterDetailButtonHandler('&relfids=33&sourceRID=57&destrid=" & [Contact info ID#] & "', 'bt37k7pc8'))"
I think 57 refers to the job that the tasks are copied from.
I would like to have the code refer to a differing job based upon a choice made on the form thereby choosing which template to copy.
How would I set that up to make that choice and show the RID for the differing job to copy from? I can see that a loop may be formed.
There is a way I think but how without the loop?
Loran Prince
Prince Finishing Inc
Edmonton's Premier Finishing Company
780-700-9057
8420 34A ave
Edmonton AB T6K 0C2
greatservice@princefinishing.com
MarkShnier__You
Qrew Legend
2 years agoCan you tell me how many Parent Template records you have. If it's not too many, one solution is to just have a multiple choice field with the say 10 choices and then a hard coded calculation formula to calculate which Record ID to pull from.
In rethinking my suggestion, there is the possibility that if the related the table to itself in order to pull in the parent template record ID, the copy parent child may not allow that kind of what they call looping relationship.
so you an have a field like
Case([Project Type],
"Big", 123",
"Small", "124",
"Custom", "125")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------