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__YouQrew Legend
Qrew LegendIf 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
------------------------------
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
------------------------------ - 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
------------------------------Mark,
I have this formula now:
(List
("<br>",
ToText(([Minimum Record ID# 1st vents - Quantity])),
ToText([Minimum Record ID# 2nd vents - Quantity]),
ToText([Minimum Record ID# 3rd vents - Quantity]),
ToText([Minimum Record ID# 4th vents - Quantity]),
ToText([Minimum Record ID# 5th vents - Quantity])))
And it displays it as:
1
0
0
0
0
How can I edit the formula to exclude the fields that are null? It is converting my blank field to "0" instead of leaving it blank and collapsing the field.
Thank you,
Mike Klausing
------Original Message------
You 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
------------------------------
