Formula Rich text nested IF statement List
I am following this thread: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=35640&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendList("\n",
and then list all your fields or expressions which might or might not be null
)
The list function well concatenate any values Which are not now and in this case the separator will be the new line
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
and then list all your fields or expressions which might or might not be null
)
The list function well concatenate any values Which are not now and in this case the separator will be the new line
Character.
The value need to be text values, not numeric values.
The value need to be text values, not numeric values.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- MarkShnier__YouIf the field is Rich Text Type, then use
List("<br>", fields comma separated)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------That gives me the error: Expecting text but found number.
It does work if I change it to a text field, but I am looking at doing this for both text fields and numeric fields.
Thank you,
Mike Klausing
------Original Message------
If the field is Rich Text Type, then use
List("<br>", fields comma separated)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- MarkShnier__YouYou can use the Function ToText([my numeric field])
to convert a number to Text
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
