I am having difficulty getting a statement to work. Basically I want to have field 1 take "x" value and then return an "x" value in Field 2. 3 options for field 1 that returns the value of that option into field 2.
This is what I have that returns errors:
If (Field 1 eq "A") then (Field 2 eq "10")
elseif
If (Field 1 eq "B") then (Field 2 eq "8")
elseif
If (Field 1 eq "C") then (Field 2 eq "6")
endif
Can someone help me with the correct syntax to perform this operation? I am sure I have something wrong somewhere. Or maybe I am using the wrong type of statements for this operation.
Thank you!
Tom
Views
Replies
Total Likes
1. You can't have a 'elseif' followed by an 'If' because your 'elseif' is already an 'If' statement
2.FormCalc 'if' statement operators are used as letters, so to have 'equal to' is 'eq', to have 'lower than' is 'lt', to have 'greater than' is 'gt', to have 'lower or equal to' is 'le'... etc...
To assign a value to a field or variable you must use the '=' sign
If (Field1 eq "A") then
Field2 = "10"
elseif (Field1 eq "B") then
Field2 = "8"
elseif (Field1 eq "C") then
Field2 = "6"
endif
Views
Replies
Total Likes