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 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
------------------------------- MarkShnier__YouThis can definitely be done.
Let's try the most elegant solution first.
Locate that Quantity field on the source child record, and there will likely be a checkbox that says to treat blank as zero. Uncheck it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------