Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoCan you post your existing code to run the import?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
RyanStanford1
6 years agoQrew Captain
Agreed with Mark, need to see the code...
how I would implement this is to have some JavaScript to get the current value of the field, +1 to it, and update the field as a separate call that would happen at the same time as the import.
------------------------------
Ryan Stanford
------------------------------
how I would implement this is to have some JavaScript to get the current value of the field, +1 to it, and update the field as a separate call that would happen at the same time as the import.
------------------------------
Ryan Stanford
------------------------------
- EverettPatterso6 years agoQrew CaptainYes, but if you just want a simple, native solution you can use numeric field + formula URL
var number mynewvalue = [NumericTest] + 1; URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_15=" & URLEncode($mynewvalue)
------------------------------
Everett Patterson
------------------------------- MarkShnier__You6 years ago
Qrew Legend
.... but we need to see your current code in order to help you sequence the counter formula above combined with the import and then refresh the page you are on.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------ - WallaceYeboah5 years agoQrew MemberHi Everett,
Great insight - Can you expound on this a bit more.
My understanding is you would first need to create a numeric field which in this case would be "Numeric Test". You would then place this formula into a formula url field correct? Also would "fid_15" be the field id for "Numeric Test"?
Lastly which field would hold the count? Would it be the url field or the numeric field? I'm guessing the numeric but not entirely sure.
------------------------------
Wallace Yeboah
------------------------------