Calculation function

  • Resolved johnt22

    (@johnt22)


    2 years, 6 months ago

    I’m making an estimate form with the calculated form plugin, and I’m trying to add a function to get the date, if it’s a Sunday I wanna add $10 to the summary

    • This topic was modified 2 years, 6 months ago by johnt22.

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

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @johnt22

    Thank you very much for using our plugin. I’ll try to describe the process with a hypothetical equation.

    Assuming you have the equation fieldname1+fieldname2 and you want to add $10 to the previous sum if the user selects a Sunday through the date field fieldname3.

    The plugin includes the WEEKDAY operation that returns the number 1 for Sunday. So, you can edit the hypothetical equation as follows:

    fieldname1+fieldname2+IF(WEEKDAY(fieldname3) == 1, 10, 0)

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Calculation function’ is closed to new replies.