Javascript clock in

Question

Struggling just a big here. So I made a javascript codepage for clock in/out, but when I am trying to pass certain parameters in the clock in section of the code it will only let me pass them as a text, although, they are date/time fields or related record fields. Could someone assist me in the formatting here?&nbsp;
Code Page:
function showModalMessage(message, title, url) {&nbsp; &nbsp; $('#modalmessage').empty();&nbsp; &nbsp; $('#modaltitle').empty();&nbsp; &nbsp; if (title === undefined || title === null) {&nbsp; &nbsp; &nbsp; &nbsp; title = 'Alert!';&nbsp; &nbsp; }&nbsp; &nbsp; $('#modaltitle').append(title);&nbsp; &nbsp; $('#modalmessage').append('&lt;p&gt;' + message + '&lt;/p&gt;');&nbsp; &nbsp; $('#mymodal').modal('show');
&nbsp; &nbsp; $('#closediv').click(function() {&nbsp; &nbsp; &nbsp; &nbsp; window.location.href = url;&nbsp; &nbsp; });
}
function closeModalMessage() {&nbsp; &nbsp; $('#mymodal').modal('hide');
}
var fieldValue = function(field) {&nbsp; &nbsp; return $(field[0]).text();};
$.when(&nbsp; &nbsp; $.getScript('?a=dbpage&amp;pageid=13')
).done(function() {&nbsp; &nbsp; $.quickbase.api('API_DoQuery', {&nbsp; &nbsp; &nbsp; &nbsp; dbid: dbids._DBID_TIME_ENTRIES,&nbsp; &nbsp; &nbsp; &nbsp; query: '{171.EX.1}AND{172.EX.1}',&nbsp; &nbsp; &nbsp; &nbsp; clist: '3.174',&nbsp; &nbsp; &nbsp; &nbsp; slist: '3',&nbsp; &nbsp; &nbsp; &nbsp; fmt: 'structured',&nbsp; &nbsp; &nbsp; &nbsp; promise: true
&nbsp; &nbsp; }).then(function(data) {&nbsp; &nbsp; &nbsp; &nbsp; if ($('errcode', data).text() === '0') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($('record', data).length &gt; 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; window.location.href = URLRoot + dbids._DBID_TIME_ENTRIES + '?a=q&amp;qid=83';
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else if ($('record', data).length === 1) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let rid = fieldValue($('f[id=3]', $('record', data)[0]));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; let curTime = fieldValue($('f[id=174]', $('record', data)[0]));&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //console.log(rid);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //console.log(curTime);
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $.quickbase.api('API_ImportFromCSV', {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbid: dbids._DBID_TIME_ENTRIES,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; records_csv: rid + ',' + curTime,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; clist: '3.15',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; promise: true
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }).then(function(data) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($('errcode', data).text() === '0') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $('#mymodal').modal('show');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //sorryDialog('You have successfully clocked out at ' + curTime, 'Clocked Out', URLRoot + appID);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; showModalMessage('You have successfully clocked out at ' + curTime, 'Clocked Out', URLRoot + appID)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; showModalMessage('There was an error trying to process your request: &lt;BR&gt;' + $('errdetail', data).text(), 'Error', URLRoot + appID);
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //sorryDialog('You have successfully clocked in', 'Clocked In', URLRoot + dbids._DBID_TIME_ENTRIES + '?a=API_AddRecord&amp;apptoken=' + token + '&amp;rdr=' + URLRoot + appID);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $.quickbase.api('API_AddRecord', {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dbid: dbids._DBID_TIME_ENTRIES,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; field: [&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fid: 25,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value: 'Work'&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fid: 16,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; value: 'In' // This will set FID 7 to the current date/time value&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; fid: 125,&nbsp; &nbsp; &nbsp; &nbsp; value: '1'&nbsp; &nbsp; },&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; fid: 13,&nbsp; &nbsp; &nbsp; &nbsp; value: rid.toString()&nbsp; &nbsp; }&nbsp; &nbsp; ],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; promise: true
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }).then(function(data) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($('errcode', data).text() === '0') {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; showModalMessage('You have successfully clocked in', 'Clocked In', URLRoot + appID)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; showModalMessage('There was an error trying to process your request: &lt;BR&gt;' + $('errdetail', data).text(), 'Error', URLRoot + appID)
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //showModalMessage('You have successfully clocked in', 'Clocked In', URLRoot + dbids._DBID_TIME_ENTRIES + '?a=API_AddRecord&amp;apptoken=' + token + '&amp;rdr=' + URLRoot + appID)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; console.log($('errdetail', data).text(), 'Data Retrieval Error', 'false');&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; });

Issue Area:

});------------------------------William Hunter------------------------------

chayceduncan · Answer

From reviewing it in a text editor, it looks like you've got a scoping issue where the else {} condition that you're utilizing rid and its causing an issue where rid isn't set and so I'm guessing you're getting an 'rid is not defined' error. I've copied how I see it below with it condensed a little:&nbsp;

In the above, you're setting the value of rid at line 44 in the elseif condition after the response of your query and you're checking to see if the&nbsp;# of records is = 1. In this case, rid is contained within the scope of that IF statement from lines 43 - 59.&nbsp;
In the event that you don't have any records returning from your query - your code will jump down to line 60 into the else {} condition which has a different scope from lines 60 to 92 - but inside of that scope you're not setting rid anywhere. Basically since you're not processing the else if condition - then rid is never getting set anywhere and so its not being defined.&nbsp;
In order to fix it you will need to either remove rid from your addrecord call or define it some other way within the else {} scope so that it can be used.&nbsp;
------------------------------Chayce Duncan------------------------------

williamhunter2 · Answer

Got it working thank you!------------------------------William Hunter------------------------------

Forum Discussion

Javascript clock in

2 Replies

Related Content

PayPal JavaScript SDK

Native/Alternative Solution for JavaScript

Clock Channel in Pipelines

Using printed QR codes to Clock In or Clock Out of a Task

Copy to Clipboard no Javascript

Recent Discussions

Filter Monthly, Quarterly, Yearly from one Date field

Extrapolating nuanced data

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record