Calculation: If

[Olaf Welling]

I can’t get, why this calculation is returning the “THEN”-result (the concated text) in all ; never the “ELSE“-result – no matter what the field <ul>Buchtyp contains.
IF ( <ul>Buchtyp</ul>= "Hardcover"; Concat (<ul>Preis</ul>;" € · ISBN ";<ul>ISBN_NR</ul>); <ul>ISBN_o_Str</ul>)

(underlined field names not typed, but entered via drag and drop)
Any help?

[Olaf Welling]

I got, meanwhile, at least that “ul” is for an unsorted list, not for “underline” …

I can’t get, why this calculation is returning the “THEN”-result (the concated text) in all records; never the “ELSE“-result – no matter what the field Buchtyp contains.
IF ( Buchtyp= “Hardcover”; Concat (Preis;” € · ISBN “;ISBN_NR); ISBN_o_Str)

(bold; field names not typed, but entered via drag and drop)
Any help?

[Daniel Leu]

Try with IFEQUAL instead of IF:

IFEQUAL ( Buchtyp; "Hardcover"; CONCAT (Preis;" € · ISBN ";ISBN_NR); ISBN_o_Str)

Cheers, Daniel

---
See https://lab.danielleu.com/tapformspro/ for scripts and tips&tricks

[Olaf Welling]

Thank you very much! (Being a former FileMaker-user some logics in Tap Forms are still very odd to me)

[Author]

Posts