Condition formulas

  • Resolved 0rbita

    (@0rbita)


    7 years, 3 months ago

    Hello,

    I have seen the tutorial page about Condition in Formulas, but I could not apply it.

    Here’s what I am trying to do:

    – I have a multiple choice field and every choice has its own amount.
    – I have another field calculating foot square.
    – I need a field that can calculate the amount of the first multiples choice field multiplying it by the second field
    (meaning: amount * foot square)

    And what I can not do is to tell the form which amount it should pic to every multiplying field.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter 0rbita

    (@0rbita)

    7 years, 3 months ago

    Hello again,

    I have another question about condition in formulas…
    Let’s say I calculate something like that:

    field1*field2

    If the value is less than 0.5, how can I tell that field to show “0.5” instead of the actually calculated number?

    Thank you

    (sorry, I am a layman on these matters)

    Plugin Author EDGARROJAS

    (@edgarrojas)

    7 years, 3 months ago

    Hello!

    Regarding your first question, please check the section “Using Dropdown, checkboxes and radio buttons in formulas”, it explain how to assign values to a dropdown:

    https://sfmanual.rednao.com/documentation/calculatedfields/creating-formulas/

    After assigning the values all you need to do is a formula that has exactly that operation (firstfield*secondfield).

    Hope this make sense but if it doesn’t please let me know!

    Regarding your second question, too keep things organized, could you create another thread for that?

    Thread Starter 0rbita

    (@0rbita)

    7 years, 3 months ago

    Hello,

    Oh, yes, I have seen that… But with that approach I can never see all the costs, I mean, if I want to check and send an email to a client containing every cost of every service, for example, then I could not do it using that tutorial.
    Is there some way I add a “show all” button and let everything showing?

    Well, I could, but that will regenerate more conditional logic and I was trying to have a minimum of them.
    But okay, I will do it.

    Thank you

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Condition formulas’ is closed to new replies.