How do I code the following: Select from a combo box, each item has a value, the value reflects in a different filed. If there is nothing selected then the value in the field must be 0?
J

if text('Year 1 2017') = "Council Reg" then
            'Council Registration' := "1200"
else
            "0"

Ninox Profile

Try this:

if text('Year 1 2017') = "Council Reg" then
            'Council Registration' := "1200"
else if text('Year 1 2017') = false then
            "0"

 

J

Thanks Nick, perfect, however, when I select one of the other items on the combobox with a values then the "Council Reg" revert back to "0" - how do I select more than one and still keep the value of the already selected value in their fields ? If I select "Council Reg" then the value in the field is 1200, plus then I selct WPTP 1 with a vaue of 2000 in a diferent/next field. This gives me a total value of 3200. (I have about 6 posible items to select from. (this is my first time using Ninox, with no coding knowlage, so forgive the ignorance) 

Ninox Profile

Some screen shot would be nice. I need more details... what type of fields are you using etc.

Reply