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