Create a new parent record based on criteria on child record

Question

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

markshnier__you · Answer

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

jeremycohen · Answer

Hey Mark,Thank you for your response.I need to add a parent record while in the child form.I need it to create a new parent record while in the child based on a situation within the child record.&nbsp; I took a stab at trying it as an automation but I definitely would prefer it to be a URL button as it is a much easier and efficient user experience.Details:&nbsp; There is a commitment out there which states a budget (Parent Record) but the rules dictate that it can be overspent up to a certain threshold.&nbsp; As the invoice is processed against the commitment within the child record if it falls within that threshold then a new parent record can be established for the difference.------------------------------Jeremy Cohen------------------------------

markshnier__you · Answer

You can create a record by using the API for API_AddRecord, and I can help you with the syntax for that once I understand your work flow.

You are sitting on a child record. So via lookups, a child can know any fields from the Parent and they can be used by the API. So you click and create a parent record and then what? Where do you want to land the user and does the child you are sitting on need to get attached to the new parent?

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

jeremycohen · Answer

Hey Mark,Sorry for the delayed response.I would be sitting in the child record and need to initiate a new parent record.&nbsp; The two do not need to tie together.&nbsp; The system I am integrating with through csv reads each change as an individual record so it would be a new line for every addition or subtraction.&nbsp; The user just needs to initiate the new record being generated.&nbsp;&nbsp;The user will be in the form of the child.&nbsp; This is why I was leaning towards a url button.&nbsp; I was just having a hard way to go with how to replicate a parent record associated to the child form and then make a few minor alterations to that record so that it is unique.The attachment will happen more external to the system than internal.------------------------------Jeremy Cohen------------------------------

markshnier__you · Answer

If you want to create a parent record and land the user on the patent record, the formula would beURLRoot() &amp; "db/" &amp; [_DBID of the Table name from Advanced Properties]&nbsp;&amp; "?act=API_AddRecord"&amp; "apptoken=xxxxxxxxxxxx" // you need this line if you have left th3 app to require Application tokens&amp; "&amp;_fid_7=" &amp; URLEncode([some text field])&amp; "&amp;_fid_8=" &amp; ToText([some numeric field])&amp; "&amp;displayrec=1"&nbsp;I have put an app in the exchange called URL formulas for dummies which can help you with some of the syntax. &nbsp; &nbsp; There is also the API guide which describes the different API calls.&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Create a new parent record based on criteria on child record

7 Replies

Related Content

Create a formula duration over 5 years

Get latest child record on parent record

How to add list of attachments on child record from parent record

Bulk create child records from selection list

Send Weekly Reminder Email based on Criteria

Recent Discussions

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.

Share your feedback on the new Qrew Discussions