Forum Discussion

BenBen2's avatar
BenBen2
Qrew Member
6 years ago

Rich Text Formula field creating records in triplicate in child table

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.