Hi All;
Thanks in advance for any contributions on my issue and apologies for my poor explanation of the problem
I have a vehicle parts application table with a series of related fields that refer to [grouped] variations of a particular aspect, for example;
Fh12_from [model year] > Fh12_To[model year], then Fh13_From [model year] > Fh13_To[model year] and so on
My issue is how to correctly format an expression to check if a field has an entry or is blank [Null], then only if there is some value in the field to step through the following processes.
I want to create a single additional calculated field for a record that only processes fields that have an actual entry value, with each sub-group separated by "comma-space"
[FH12 (from) > (To), FH13 (From) > (To), FH16 (From) > (To), etc]
so if a value exists then add it together with the correct text prefix, if no value, then ignore the field.
I can just concatenate all the actual fields together using;
alltrim("FH12 "+ Fh12_From)+", "+alltrim("> "+Fh12_To)+", "+alltrim("FH13 "+ Fh13_From)+", "+alltrim("> "+Fh13_To) [and so on]
This initial code seems ok for a small part of what I need but after many failed attempts and much research of alpha documentation / videos , message board etc, I cannot work out the way to add the conditional aspect and avoid all the unwanted / incorrect text and comma separators this produces
All fields are specified as 'char' type and I need the text prefixes to be only used within the calculated field[s] and of course with the correct corresponding data field entry
Hope this makes some sort of sense, of course I may be trying to go about this altogether wrongly in which case any thoughts / guidance would be appreciated
The resulting calculated field[s] are for display purposes only on a desktop form, as part of a report and within a web application if that helps with context
Thanks again
Bm
Thanks in advance for any contributions on my issue and apologies for my poor explanation of the problem
I have a vehicle parts application table with a series of related fields that refer to [grouped] variations of a particular aspect, for example;
Fh12_from [model year] > Fh12_To[model year], then Fh13_From [model year] > Fh13_To[model year] and so on
My issue is how to correctly format an expression to check if a field has an entry or is blank [Null], then only if there is some value in the field to step through the following processes.
I want to create a single additional calculated field for a record that only processes fields that have an actual entry value, with each sub-group separated by "comma-space"
[FH12 (from) > (To), FH13 (From) > (To), FH16 (From) > (To), etc]
so if a value exists then add it together with the correct text prefix, if no value, then ignore the field.
I can just concatenate all the actual fields together using;
alltrim("FH12 "+ Fh12_From)+", "+alltrim("> "+Fh12_To)+", "+alltrim("FH13 "+ Fh13_From)+", "+alltrim("> "+Fh13_To) [and so on]
This initial code seems ok for a small part of what I need but after many failed attempts and much research of alpha documentation / videos , message board etc, I cannot work out the way to add the conditional aspect and avoid all the unwanted / incorrect text and comma separators this produces
All fields are specified as 'char' type and I need the text prefixes to be only used within the calculated field[s] and of course with the correct corresponding data field entry
Hope this makes some sort of sense, of course I may be trying to go about this altogether wrongly in which case any thoughts / guidance would be appreciated
The resulting calculated field[s] are for display purposes only on a desktop form, as part of a report and within a web application if that helps with context
Thanks again
Bm
Comment