Joined: 07 Aug 2014
Online Status: Offline
Posts: 6
Topic: Combining Text and field in Formula Posted: 11 May 2015 at 5:44am
I am trying to include both a text phrase and a field into a formula.
I am using an IF/THEN statement. If a defined field is equal to "SUB" then I want the footer to say both "Text" and the data from the {example.sub} field.
When I try:
IF {field} = "SUB" THEN "Text"
-then "Text" appears in the footer.
When I try:
IF {field} = "SUB" THEN [example.Sub}
-then the example.sub data appers in the footer.
When I try:
IF {field} = "SUB" THEN "Text" {example.Sub}
-I get an error that {example.sub} does not appear to be part of the formula.
When I try:
IF {field} = "SUB" THEN "Text";{example.Sub}
-I only get the example.sub in the footer.
How can I get BOTH of the items I want in the same formula?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum