JohnThomas
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Removing Holidays and Weekends between two dates and calculating days
Entire Year Basically i will have a table called "Off" in that table i will have date field "Hoilday Date" , so i will create 14 or 15 records each year . So those records will be my Holidays for the year. I have another table "Records" , in that table i have two fields "Start" and "End" date fields , so i will select a date in both two fields , for example 15/09/2017 - 20/09/2017 so basically 16 and 17 are weekends and consider 18-09-2017 [Which i added as a record in "Off" table] is a holiday , then i get the number of days as 3 [15 -09-17, 19-09-17 , 20-09-17] . Is there any native quickbase option. Many Thanks in advance130Views0likes0CommentsRemoving Holidays and Weekends between two dates and calculating days
Each year i will have number of hoildays , so i need to add in a table as records so from there i need to fetch the holiday dates and calculate in another table where the two date fields are there. Is there any native quickbase option.356Views2likes20CommentsRe: Don't save the record if the function returns false otherwise save the record
I got the solution. i hope this will help anyone DoSave = (function(fn){ return function(){ var resultofalertMSGS = alertMSGS(); if (resultofalertMSGS === false) { return false; }else{ var result=fn.apply(fn, arguments); return result; } } })(DoSave);5Views0likes0CommentsDon't save the record if the function returns false otherwise save the record
I have a child function alertMSGS so the alertMSGS function checks the values in four variables and gives a alert message that they are not equal, so it will return false to the parent function which is DoSave() its a closure function , from my knowledge . So if the return is false i need to exit the save otherwise need to perform the save. !! See below . Many Thanks in advance function alertMSGS(){ <br> var currentWeekEarning = parseFloat( $("#_fid_19").val() ); var totalYearEarning= parseFloat( $("label[for=_fid_39]").next("div").text().replace('$', '').replace(',', '') ); var currentLoss = parseFloat($("#_fid_20").val()); var totalYearLoss= parseFloat($("label[for=_fid_38]").next("div").text().replace('$', '').replace(',', '') ) if( (currentWeekEarning != totalYearEarning) ){ alert("currentWeekEarning Not Equal to totalYearEarning"); return false; } if ( currentLoss != totalYearLoss) { alert(' currentLoss Not Equal to totalYearLoss'); return false; } } DoSave = (function(fn){ return function(){ var resultofalertMSGS = alertMSGS(); if (resultofalertMSGS === false) { // so if the function returns false then i need to exit from the (DoSave Function) and if it satisfies then i need to perform the (DoSave Function) } var result=fn.apply(fn, arguments); return result; }; })(DoSave); I got the DoSave() function code from quickbase itself , so i hope i will get a reply on this.4Views1like1CommentRe: Adding 3 html formula-involved texts fields (number of days)
So can you elaborate more , I understand like There are three formula text fields which gives the number of days as output like [Formula 1] = 12 [Formula 2] = 10 [Formula 3] = 14 On 4th field which is [Formula 4] , you need to add the 12+10+14 and show the sum as 36 in the last field . Is this is what you are asking !!!0Views0likes0Comments