Skip to main content
Question

Create a new parent record based on criteria on child record

  • October 15, 2019
  • 0 replies
  • 70 views

I am working with a record tie in of a parent table being a total volume while a child record utilizes an amount of the parent.

In certain instances the child record can create more volume in the parent, but with systems it has to be in a new line.

So the long and short...

I need to create a URL button that would get the parent info that is related to what is being used in the child and create a new record in the parent with that criteria.

I started a formula with the API_GetrecordInfo  Which does great in giving me it all.  Now I just need to know how to "Copy" all of that data and then edit the record with the information created in the child record.

I figured I could use javascript to form 3 URL's to accomplish this, just not sure the middle one.

1st "Get info" which would pull all the information in the parent.

2nd "Copy info" which would probably be a generate new record with the information of "Get info"

3rd "Edit info" which I would believe is a simple translation of a few fid's to the represented data.

I hope I did a good job explaining this.  Any help would be very much appreciated!

------------------------------
Jeremy Cohen
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • October 16, 2019
Please clarify wha type of record you want to add, (Parent or Child) and if you want the button to be on the Oarent or the child.

also please explain why you can't use the native Add child button which is created by the relationship.  Is it because you want a button to actually create the extra child Record and refresh the screen?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------