0
Working with formulas
I am want to see if TABLE 1's field A is between 1 and 26 inculsive. If True, value goes into field B as new record.
In "Visual" mode and using the if/then/else function, I can place field A into the first parameter, I cannot enter any logic criteria.
in "Text" mode i do not know the conventions. I have used parenthes, commas, the statements if then else. All knds of ways using various syntax from past experience.
Broolynguydbs
copy it into text field B.
example 2:
2 replies
-
Field B is in a different table?
-
let v := 'field a' > 0 and 'field a' < 27;if v thenlet a := 'field a';let p := (create 'TABLE 1');p.('field b' := a)end
Content aside
- 4 yrs agoLast active
- 2Replies
- 591Views