Data_SystemAnal
6 years agoQrew Cadet
Rich formula button to open in another tab
I have this formula that allows user update information from one table to another table, the problem is my formula have some script and because of that I need open this process in another tab, what part I missing in my formula below
Type: button: (Update data)
"<a style=\"text-decoration:none; background: #f90; border-radius: 5px; color: #fff; display: inline-block; padding: 8px 20px; text-align: center; text-shadow: none; \"href='"&URLRoot()&"db/"& [_DBID_CONTACT_UPDATES]&
"?a=API_GenAddRecordForm"&
"&_fid_52=" & URLEncode ([Contact ID2])&
"&_fid_6="&[Contact Type]&
"&_fid_19="&[First Name]&
"&_fid_21="&[Middle Name]&
"&_fid_34="&[Land Line Phone Number]&
"&_fid_50="&[Previous Phone Number]&
"&_fid_8="&[Email]&
"&_fid_31="&[Facebook Email]&
"&_fid_32="&[Facebook Username]&
"&_fid_30="&[Instagram Username]&
"&_fid_43="&[AuthorizedContact]&
"&_fid_44="&[Emergency]&
"&ifv=52"&
"'>Update Contact</a>"
Type: button: (Update data)
"<a style=\"text-decoration:none; background: #f90; border-radius: 5px; color: #fff; display: inline-block; padding: 8px 20px; text-align: center; text-shadow: none; \"href='"&URLRoot()&"db/"& [_DBID_CONTACT_UPDATES]&
"?a=API_GenAddRecordForm"&
"&_fid_52=" & URLEncode ([Contact ID2])&
"&_fid_6="&[Contact Type]&
"&_fid_19="&[First Name]&
"&_fid_21="&[Middle Name]&
"&_fid_34="&[Land Line Phone Number]&
"&_fid_50="&[Previous Phone Number]&
"&_fid_8="&[Email]&
"&_fid_31="&[Facebook Email]&
"&_fid_32="&[Facebook Username]&
"&_fid_30="&[Instagram Username]&
"&_fid_43="&[AuthorizedContact]&
"&_fid_44="&[Emergency]&
"&ifv=52"&
"'>Update Contact</a>"