Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
9 years ago
We had this issue as well and resolved it with an onmouseover.

var text base = URLRoot() & "db/" & Dbid();
var text rdr = "&rdr=" & URLEncode($base & "?a=dr&rid=" & [Record ID#]);
var text url = $base & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_<TARGET FID>=";

var text jquery="$(\"#timeTarget\").attr(\"href\",\""&$url&"\"+ now.replace(\",\",\"\") + \""&$rdr&"\")";

"<a id='timeTarget' href ='void' class='Vibrant' onmouseover='"&"var now = new Date().toLocaleString();"&$jquery&" '>BUTTON NAME</a>
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    9 years ago
    Hi Nathan,

    I have a field called Flag that captures that button has already clicked. It means if someone has already started their time then, it will give an alert says 'Please end your shift first'.

    In above formula, how can I use if condition in which Ist part will capture time and second part will give an alert?

    Thanks,
    Gaurav
  • GauravSharma3's avatar
    GauravSharma3
    Qrew Commander
    8 years ago
    I want to show an alert if the shift has already started.

    Here is my formula:

    var text base = URLRoot() & "db/" & Dbid();
    var text rdr = "&rdr=" & URLEncode($base & "?a=dr&rid=" & [Record ID#]);
    var text url = $base & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_478=1" & "&_fid_475=";
    var text jquery="$(\"#timeTarget\").attr(\"href\",\""&$url&"\"+ now.replace(\",\",\"\") + \""&$rdr&"\")";
    If([Workday Flag]=0,
    "<a id='timeTarget' href ='void' class='Vibrant' onmouseover='"&"var now = new Date().toLocaleString();"&$jquery&" '>Start Work</a>",
    "javascript:alert('Please end your workday first.')")

    Thanks,
    Gaurav