Forum Discussion
MarkShnier__You
Qrew Champion
If you want to create a parent record and land the user on the patent record, the formula would be
URLRoot() & "db/" & [_DBID of the Table name from Advanced Properties]
& "?act=API_AddRecord"
& "apptoken=xxxxxxxxxxxx" // you need this line if you have left th3 app to require Application tokens
& "&_fid_7=" & URLEncode([some text field])
& "&_fid_8=" & ToText([some numeric field])
& "&displayrec=1"
I have put an app in the exchange called URL formulas for dummies which can help you with some of the syntax. There is also the API guide which describes the different API calls.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
URLRoot() & "db/" & [_DBID of the Table name from Advanced Properties]
& "?act=API_AddRecord"
& "apptoken=xxxxxxxxxxxx" // you need this line if you have left th3 app to require Application tokens
& "&_fid_7=" & URLEncode([some text field])
& "&_fid_8=" & ToText([some numeric field])
& "&displayrec=1"
I have put an app in the exchange called URL formulas for dummies which can help you with some of the syntax. There is also the API guide which describes the different API calls.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
JeremyCohen
5 years agoQrew Member
Hey Mark,
That works for just adding a record. So your saying I should just create lookup fields for every possible field I need when it is related and then use the url to simply add a new record...i guess that would be a much simpler approach to it.
In that case any fields I'm changing due to the conditional I could just tie directly to the fid....I'll try the approach. Thank you very much for the help Mark!
------------------------------
Jeremy Cohen
------------------------------
That works for just adding a record. So your saying I should just create lookup fields for every possible field I need when it is related and then use the url to simply add a new record...i guess that would be a much simpler approach to it.
In that case any fields I'm changing due to the conditional I could just tie directly to the fid....I'll try the approach. Thank you very much for the help Mark!
------------------------------
Jeremy Cohen
------------------------------
- MarkShnier__You5 years agoQrew ChampionExactly, your initial thinking was way overthinking what was required. It's just the API to ADD a record and the only complexity is where to land the user after the button is pushed.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------