Calender

  • Resolved MasG

    (@dhevilz)


    1 year, 4 months ago

    hello, I want to use for day counting purposes..
    For example, when I start work on July 1st, it is 9 days after July 1st which is what date?

    then I need 3 columns,
    the first column is for specifying the start date, the second column is for specifying the number of days, and the third column is the result column

    like the link that I have included, the process cannot be done,
    where when column one chooses the date it does not affect the results in column three.

    because in this plugin, the date is always set at today’s date, so calculations can only be done for today and additional days ahead,

    can I set it so that it can adjust to the date specified in column 1? Thank You

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @dhevilz,

    Thank you very much for using our plugin.

    If fieldname1 is the date field, and fieldname2 the number field, the equation in the calculated field (fieldname3) can be implemented as follows:

    CDATE(fieldname1+fieldname2, 'mm/dd/yyyy');

    To distribute the fields into columns there are different alternatives.

    The easiest solution would be to insert a DIV field in the form, selects the “3 Columns” option through its “Columns” attribute, and then drag the fields fieldname1, fieldname2, and fieldname3 into the DIV field in the dashboard.

    Please watch the following video:

    https://youtu.be/5wguFUR4pD8

    About default dates in date fields they use the today date by default, but you can enter a different date through their “Default Date” attribute.

    Also, if you want leave the date field empty, please, leave empty the “Default Date” and “Predefined Value” attributes, and tick the “Use predefined value as placeholder” checkbox.

    In this case, where the date field is empty by default, you should check if it is empty or not in the calculated field as part of the equation before evaluating the mathematical operation. So, you can edit the previous equation as follows:

    IF(fieldname1, CDATE(fieldname1+fieldname2, 'mm/dd/yyyy'), '');

    Best regards.

    Thread Starter MasG

    (@dhevilz)

    can I change the date format of 30/07/2023 to 30 July 2023 ? thanks

    Plugin Author codepeople

    (@codepeople)

    Hello @dhevilz

    No, I’m sorry. In date fields the supported formats are mm/dd/yyyy, dd/mm/yyyy, yyyy/mm/dd, and yyyy/dd/mm

    Best regards.

    Thread Starter MasG

    (@dhevilz)

    ok, thank you very much

    Plugin Author codepeople

    (@codepeople)

    Hello @dhevilz

    The date output in the calculated fields can have the 30 July 2023? structure. But in this case, you must implement the equation as follows:

    
(function(){
  if(fieldname1){
    var d = fieldname1+fieldname2;
    return DAY(d)+' '+MONTHNAME(d)+' '+YEAR(d);
  }
  return '';
})()

    Best regards.

    Thread Starter MasG

    (@dhevilz)

    nice.. big thanks for you..!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Calender’ is closed to new replies.

Tags