Forum Discussion

LoranPrince's avatar
LoranPrince
Qrew Member
2 years ago

Copy Master detail records from a button based upon a selection on the form

I am wanting to import or copy a set of master records from a template job(one of many so I need to be able to select before I push the button) , The selection being made on the jobs form. This proce...
LoranPrince's avatar
LoranPrince
Qrew Member
2 years ago
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

princefinishing.com

 

 



MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 years ago

Can 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
------------------------------