Rich Text Formula field creating records in triplicate in child table

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • In Progress
  • (Edited)
I created a button using a Rich Text Formula field that will add records to a child table.  The button is being used in an automated daily email employees receive.  This is producing records in triplicate in the child table.  Here is the formula that I am using:

var text style = "style=\" text-decoration: none; background: #34a853; border-radius: 5px; color: #fff; display: inline-block; padding: 6px 24.5px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-align: center; text-shadow: none;";

var text url = URLRoot() & "db/" & [_DBID_ROSTER_CHECKINS] & "?a=API_AddRecord" & "&_fid_6=Approved" & "&_fid_7=" & [Registered Email] & "&rdr=" & URLEncode("https://****.quickbase.com/db/*********?a=dbpage&pageID=33");

"Check In"

I used this same formula in a previous application and it did not produce the same triplicate records.  Any ideas to resolve would be appreciated.
Photo of Ben

Ben

  • 20 Points

Posted 1 month ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,774 Points 5k badge 2x thumb
Hi Ben,

Is this button creating records in triplicate every single time it is used or only some of the time?