I have a bunch of virtual fields I am using for notes and am hoping to concatenate them all into a calculated field with the field label if the virtual field is not blank. I have tried a few different formulas but have not gotten it to work when trying this with more than 1 virtual field in the calculation.
I know the formula below is not correct but gives you an idea of what I am trying to do
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Fleshzombie
I have a bunch of virtual fields I am using for notes and am hoping to concatenate them all into a calculated field with the field label if the virtual field is not blank. I have tried a few different formulas but have not gotten it to work when trying this with more than 1 virtual field in the calculation.
I know the formula below is not correct but gives you an idea of what I am trying to do
IF('[@cbParamVirtual1]' = '','','QA Checklist Error Notes- ' + '[@cbParamVirtual1]') + CHAR(10) + CHAR(10) + IF('[@cbParamVirtual2]' = '','','QA Checklist Error Notes- ' + '[@cbParamVirtual2]')
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.