ContributionsMost RecentMost LikesSolutionsRe: Copy Master detail records from a button based upon a selection on the form Ok, I will did deeper 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 Re: Copy Master detail records from a button based upon a selection on the form Ok, 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 princefinishing.com Re: Copy Master detail records from a button based upon a selection on the form Hey Mark, Thanks for the info. I have created another app and tried to connect it to Quickbase using the att ID and a token created in thge app. I used https://princefinishinginc.quickbase.com/and 2024-1 Cyber Build - General Manager (quickbase.com)which is app specific URL I get the message "This connection isn't allowed. For this app, a connection must use the credentials of an app admin" I am the app administrator because I created the app. Both apps What am i doing wrong? Thanks for all of the help Mark. 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 Re: Copy Master detail records from a button based upon a selection on the form Sounds goods, I will set that up Thanks for your help sir, As always you have the answer 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 Re: Copy Master detail records from a button based upon a selection on the form Hey Mark: There would be an abundance of the templates over time. It is a job that has many tasks and depending on the job choice,, the tasks and values varry from template to template. Can the loop be cancelled by having another app that pulls down the RID and name and then a formula field makes the RID just a number permanently with a snapshot? Or just with a snapshot field in the same app? In my mind, the snapshot number is no longer connected to the RID, What do you think? 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 Re: Copy Master detail records from a button based upon a selection on the form 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 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 process was working before they made code pages the only place you can run javascript code. The formula i Used before is this URLRoot() & "db/" & [_DBID_JOBS] & "?a=API_GenAddRecordForm&_fid_18=" & URLEncode ([Contact info ID#])& "&z=" & Rurl() This code still works in another app but the 18383 is the reference to the Job that the detail records are to be copied from. I am having problems getting the code pages to even show up on the form as a button. What am I doing wrong? ------------------------------ Loran Prince ------------------------------