0

Choice field changing text field

Hi! I have a choice field with multiple options and I'd like to change a nearby text field. Can I do this? I'm trying something like this in the "trigger after update" of the choice field:

if 'Invoice Status' = "Money Received" then
Status = "Closed"
else
Status = "Open"
end

 

Cheerio!

Rick

3 replies

null
    • Birger_H
    • 6 yrs ago
    • Reported - view

    Almost :-) Try this:

    –––
    if text('Invoice Status') = "Money Received" then
       Status := "Closed"
    else
       Status := "Open"
    end
    –––

    Birger

    • rick
    • 6 yrs ago
    • Reported - view

    Hey thanks! I had a feeling it was some symantex! 

    Follow-up question, any chance I can make the form simply display the "open" or "closed" status without it being a field that looks/acts like an "insert information" type of field? More like a heading? I haven't quite stumbled upon that yet.

    Cheerio..!

    Rick

    • Jorg
    • 6 yrs ago
    • Reported - view

    Hi Rick,

    you may use two Layout elements, e. g. Buttons without a function, just to be shown.

    One is named "Open" and the other "Closed".

    In the option "Display field only, if:" of the Button named "Open" you can write:

     

    _________

    Status = "Open" 

    _________

     

    Further more you could hide the Status field withe entering false or a 0 into the option "Display field only, if:" of the Status field.

    So you will get a Button only as a lable for the input form in order of the result of you formula. You can also use a Layout element like a Heading or simple Text, but I thought a Button would be better to be seen, especially as you can make its colour red, blue or grey.

    Best, Jörg

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 2504Views