text formula to edit multiple fields

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Attempting to edit multiple records here, but only the 1st it executing.

"<a class='Vibrant Success' href='"&Dbid()&"?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=XXX&_fid_28=In-Progress&_fid_45=Today()&rdr="&URLEncode(URLRoot()&"db/"&Dbid()&"?a=dr&rid="& [Record ID#])&"'>Kick Off</a>"
Photo of Jim

Jim

  • 20 Points

Posted 3 years ago

  • 0
  • 1
Photo of Jim

Jim

  • 20 Points
QB Support came to the rescue.. need some "& around the today function  

"<a class='Vibrant Success' href='"&Dbid()&"?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=XXX&_fid_28=In-Progress&_fid_45="&Today()&"&rdr="&URLEncode(URLRoot()&"db/"&Dbid()&"?a=dr&rid="& [Record ID#])&"'>Kick Off</a>"
thx for posting that update.
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 5,082 Points 5k badge 2x thumb
This formula will only edit the record on which you activate the button.  The redirect will simply take the user back to the record on which they started in Display/View mode.  It will not update multiple records by itself.