BenBen2
7 years agoQrew Member
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("
"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.
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.