0

Two formulas updating two seperate fields in a choice field.......Help

I tried to write this formula but it has not worked and am wondering if it is possible for two formulas to affect two seperate fields , one being Wide_W and the other Num_Width

if 'Num of Curtains' = 1 then
Wide_W := "1 x" + "  " + Wide_Widths
else
if 'Num of Curtains' = 2 then
Wide_W := "2 x" + "  " + Wide_Widths / 2
end
end

if I want to add another if, then, else to this formula to fill another field is this poosible. For example : if Num of Curtains = 1 then

Num_of_Width := "1 x"+"  "+  Curt_

else

if Num of Curtains = 2 then 

Num_of_Width:= "2 x "+"  "+ Curt_ / 2

end end 

Two formulas impacting on two seperate fields.  Trigger after update into Two Text Fields.  Not sure how to combine to sucessfully do the job, or if it can be achieved at all. I could be barking up the wrong tree. 

Thanks 

Michael

3 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Michael,

    Does this work for you?

    if 'Num of Curtains' = 1 then
    Wide_W := "1 x" + " " + Wide_Widths;
    Num_of_Width := "1 x"+" "+ Curt_
    else
    if 'Num of Curtains' = 2 then
    Wide_W := "2 x" + " " + Wide_Widths / 2;
    Num_of_Width:= "2 x "+" "+ Curt_ / 2
    end
    end

    You can add as many commands between if else as you want, just add a semicolon ; after every line code.

    Steven

    Ps: I guess We are in the same business, my wife also sells curtains ;-)

    • Ninox developper
    • Jacques_TUR
    • 3 yrs ago
    • Reported - view

    And also :

    switch 'Num of Curtains' do
    case 1: (Wide_W := "1 x" + " " + Wide_Widths;
                Num_of_Width := "1 x"+" "+ Curt_)
    case 2: (Wide_W := "2 x" + " " + Wide_Widths / 2;
                Num_of_Width:= "2 x "+" "+ Curt_ / 2)

    end;

    Or simplify by :

    Wide_W := 'Num of Curtains'+" x "+Wide_Widths/'Num of Curtains';
    Num_of_Width :='Num of Curtains'+" x "+Curt_/'Num of Curtains';

    What are all these curtains hiding? 🤔

    • Central Park Furnishings
    • Michael_McKenna
    • 3 yrs ago
    • Reported - view

    Hi Steven, that is so funny. Have you made her a data base? I have a retail business so have set up for quotes and oreders. If you have one set up I would love to see. I'm sure hers would be far better than mine. At the moment I am working on curtain making costs and because fabrics now come in widths from 1200mm to 3300mm Wide the workings get a bit crazy. Your wife is more than welcome to look at my data base if she is interested.

    thank you for your help once again. 

    Michael

Login to reply

Content aside

  • 3 yrs agoLast active
  • 3Replies
  • 377Views