Button help on formula text
Last year we made and finished an app for our company. And while we knew our information might change or be added to we knew it would never be truly finished. So it wasn't until yesterday when I was a...
Forum Discussion
Please post your actual code by copy paste. We cannot edit images.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Sorry about that. Okay here is the code for Incomplaince and N/a they are the same.
If(
[# of Open FCE File Actions]<>0, "javascript:alert('There is an open action for this question. Please close out the question before marking question In Compliance')",
"javascript:" &
"$.get('" &
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&_fid_11=In Compliance&rid=" & [Record ID#]&
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
)
and this is the formula text for Followup needed:
If(
[Compliance]="Follow-Up Needed", "javascript:alert('This question is already marked as Follow-Up Needed')",
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ACTIONS] & "?a=nwr&_fid_63=" &[Record ID#]& "&_fid_38=" &[Related Children Assignment]& " &nextURL=" & URLEncode(URLRoot() & "db/" & [_DBID_REPORTS] & "?a=dr&rid=" & [Related Childrens Report]))
)
------------------------------
Maritza Acosta Gonzalez
------------------------------
If(
[# of Open FCE File Actions]<>0, "javascript:alert('There is an open action for this question. Please close out the question before marking question In Compliance')",
"javascript:" &
"$.get('" &
URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&_fid_11=In Compliance&rid=" & [Record ID#]&
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
)
and this is the formula text for Followup needed:
If(
[Compliance]="Follow-Up Needed", "javascript:alert('This question is already marked as Follow-Up Needed')",
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=bg9b37dz5u7d4b8qz6gqcqq9wkr&rid=" & [Record ID#] & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ACTIONS] & "?a=nwr&_fid_63=" &[Record ID#]& "&_fid_38=" &[Related Children Assignment]& " &nextURL=" & URLEncode(URLRoot() & "db/" & [_DBID_REPORTS] & "?a=dr&rid=" & [Related Childrens Report]))
)
------------------------------
Maritza Acosta Gonzalez
------------------------------
- Sorry, but there may not be a way to have a pop-up message anymore. I can help you with the code to push a button and refresh the page if you like but there would not be a pop-up message.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Yes that would be fine. we just want the same actions to happen the pop up is not necessary.
Thank you again.
------------------------------
Maritza Acosta Gonzalez
------------------------------
