Auto Fill
I don't know how to explain some of this so please bear with me. I inherited this app from someone else who is no longer with the company, I'll call them X. Some background, all our bids are ass...
Forum Discussion
You just add the field to the button URL. The code below will add a new record to your table and fill out what ever fields need to be brought over.
------------------------------
QuickBase Girl
------------------------------
URLRoot() & "db/" & [_DBID_DOCUMENTS] & "?a=API_GenAddRecordForm&_fid_15=" & URLEncode ([Record ID#])&"&_fid_11=" & URLEncode([Related Client])&"&_fid_13=" & URLEncode ([Related App])& "&z=" & Rurl()
Let's break that down:
URLRoot() & "db/" & [THIS IS THE NAME OF YOUR TABLE THAT YOU ARE CREATING A NEW RECORD FOR] & "?a=API_GenAddRecordForm&_fid_THIS IS THE FIELD ID ON THE CHILD TABLE THAT DIRECTLY RELATES TO THE TABLE THE BUTTON IS ON (PARENT RECORD ID#)=" & URLEncode ([Record ID#])&"&_fid_THIS IS ANOTHER FIELD THAT YOU WANT FILLED OUT WITH SOMETHING FROM THE PARENT TABLE=" & URLEncode([NAME OF FIELD IN PARENT TABLE])&"&_fid_13=" & URLEncode ([Related App])& "&z=" & Rurl()
You can just keep adding fields to auto populate from the Parent Table.
You can find the NAME OF YOUR TABLE in the table's "Advanced Settings"
------------------------------
QuickBase Girl
------------------------------
Sorry, I'm still not getting it my URL are nearly identical. Can you tell me what I would need to change on the Table Z formula?
Table Z – doesn't auto populate:
URLRoof()&"db/"&[_DBID_BUY_OUTS] &"?a=API_GenAddRecordForm&fid_77="&URLEncode([Record ID#])&"&dfid=10"&"z= & Rurl()Table Y – auto populates:
URLRoof()&"db/"&[_DBID_OPPORTUNITY_COMPANY_ASSIGNMENTS] &"?a=API_GenAddRecordForm&fid_7="&URLEncode([Record ID#])&"&z=" & Rurl()
------------------------------
Brianne Jacobsen
------------------------------- MarkShnier__You
Qrew Legend
its URLroot (with a t)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- typo's aside. Anyone know why?
------------------------------
Brianne Jacobsen
------------------------------
