Hi Gerry,
Nice to hear from you again. This is a pretty good group isn't it?
Oops it was actually QuoteHed not OrderHed. I tried this and Vantage
gave me back a syntax error.
((if QuoteHed.CheckBox11 = true then "Please list mounting surface
details. " else "") +
(if QuoteHed.CheckBox12 = true then "Measure available wall space for
signage. " else "") )
I also tried creating a variable called Ck11 where I used
(if QuoteHed.CheckBox11 = true then "Please list mounting surface
details. " else "") and it worked ok.
Then I created a test variable where I used
Ck11 + 'test' and this returned "Please list mounting surface
details. test" which looked promising.
Then I created a Ck12 variable where I used
(if QuoteHed.CheckBox12 = true then 'Measure available wall space
for signage. " else "") and it worked ok.
Then I created a test variable where I used Ck11 + Ck12 which also gave
me a syntax error.
I also tried Ck11 + "" + Ck12 and Vantage didn't like that either. I
can use one calculated field in another, but not two.
Regards,
Linda
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerry Loranger
Sent: Tuesday, September 29, 2009 1:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ calculated field
As far as I know, you can't use a variable in a BAQ calculated column.
Please let me know if you can use a variable because that would be very
useful. But you could just assemble the string like this:
((if OrderHed.CheckBox01 = true then OrderHed.Character01 + " " else "")
+
(if OrderHed.CheckBox02 = true then OrderHed.Character02 + " " else ""))
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
lindalowney
Sent: Tuesday, September 29, 2009 10:42 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ calculated field
We use OrderHed.CheckBox11 through OrderHed.CheckBox19 to indicate a
list of
instructions for our installers to do a site check. I would like to
create a
string that combines all the instructions.
In Basic I would do something like this:
dim SiteCkNotes as string
SiteCkNotes = ""
if OrderHed.CheckBox11 = true then
SiteCkNotes = SiteCkNotes & "Note number 11. "
endif
if OrderHed.CheckBox12 = true then
SiteCkNotes = SiteCkNotes & "Note number 12. "
endif
etc...
How do I do this in a calculated field in a BAQ?
Regards,
Linda
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Nice to hear from you again. This is a pretty good group isn't it?
Oops it was actually QuoteHed not OrderHed. I tried this and Vantage
gave me back a syntax error.
((if QuoteHed.CheckBox11 = true then "Please list mounting surface
details. " else "") +
(if QuoteHed.CheckBox12 = true then "Measure available wall space for
signage. " else "") )
I also tried creating a variable called Ck11 where I used
(if QuoteHed.CheckBox11 = true then "Please list mounting surface
details. " else "") and it worked ok.
Then I created a test variable where I used
Ck11 + 'test' and this returned "Please list mounting surface
details. test" which looked promising.
Then I created a Ck12 variable where I used
(if QuoteHed.CheckBox12 = true then 'Measure available wall space
for signage. " else "") and it worked ok.
Then I created a test variable where I used Ck11 + Ck12 which also gave
me a syntax error.
I also tried Ck11 + "" + Ck12 and Vantage didn't like that either. I
can use one calculated field in another, but not two.
Regards,
Linda
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerry Loranger
Sent: Tuesday, September 29, 2009 1:15 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ calculated field
As far as I know, you can't use a variable in a BAQ calculated column.
Please let me know if you can use a variable because that would be very
useful. But you could just assemble the string like this:
((if OrderHed.CheckBox01 = true then OrderHed.Character01 + " " else "")
+
(if OrderHed.CheckBox02 = true then OrderHed.Character02 + " " else ""))
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
lindalowney
Sent: Tuesday, September 29, 2009 10:42 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ calculated field
We use OrderHed.CheckBox11 through OrderHed.CheckBox19 to indicate a
list of
instructions for our installers to do a site check. I would like to
create a
string that combines all the instructions.
In Basic I would do something like this:
dim SiteCkNotes as string
SiteCkNotes = ""
if OrderHed.CheckBox11 = true then
SiteCkNotes = SiteCkNotes & "Note number 11. "
endif
if OrderHed.CheckBox12 = true then
SiteCkNotes = SiteCkNotes & "Note number 12. "
endif
etc...
How do I do this in a calculated field in a BAQ?
Regards,
Linda
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]