Formula Rich text nested IF statement List

Question

I am following this thread: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&amp;MID=35640&amp;CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&amp;tab=digestviewerIn here they were trying to create a horizontal list based on certain criteria being met. I am trying to make a vertical list based on certain conditions being met. I have 5 quantities on a quote form that may or may not have values. I want them to appear stacked on top of each other. Like this:&nbsp; I am trying to combing Fields 525 528 531 into 1 formula field where there is logic which will collapse fields 528 and 531 if they are blank or null.

Here is my formula:if([Minimum Record ID# 1st vents - Quantity] = null,null,[Minimum Record ID# 2nd vents - Quantity]=null, null,[Minimum Record ID# 3rd vents - Quantity]=null,null,[Minimum Record ID# 4th vents - Quantity]=null,null,[Minimum Record ID# 5th vents - Quantity]=null,null,[Minimum Record ID# 1st vents - Quantity]&gt;0 ,[Minimum Record ID# 1st vents - Quantity],[Minimum Record ID# 2nd vents - Quantity]&gt;0, [Minimum Record ID# 1st vents - Quantity] &amp; "&lt;br&gt;" &amp; [Minimum Record ID# 2nd vents - Quantity],[Minimum Record ID# 3rd vents - Quantity]&gt;0,[Minimum Record ID# 1st vents - Quantity] &amp; "&lt;br&gt;" &amp; [Minimum Record ID# 2nd vents - Quantity]&amp; "&lt;br&gt;" &amp;[Minimum Record ID# 3rd vents - Quantity],[Minimum Record ID# 4th vents - Quantity]&gt;0,[Minimum Record ID# 1st vents - Quantity] &amp; "&lt;br&gt;" &amp; [Minimum Record ID# 2nd vents - Quantity]&amp; "&lt;br&gt;" &amp;[Minimum Record ID# 3rd vents - Quantity] &amp; "&lt;br&gt;" &amp; [Minimum Record ID# 4th vents - Quantity],[Minimum Record ID# 5th vents - Quantity]&gt;0,[Minimum Record ID# 1st vents - Quantity] &amp; "&lt;br&gt;" &amp; [Minimum Record ID# 2nd vents - Quantity]&amp; "&lt;br&gt;" &amp;[Minimum Record ID# 3rd vents - Quantity] &amp; "&lt;br&gt;" &amp; [Minimum Record ID# 4th vents - Quantity] &amp; "&lt;br&gt;" &amp;[Minimum Record ID# 5th vents - Quantity])------------------------------Mike Klausing------------------------------

mikeklausing · Answer

Works like a charm. Thank you&nbsp;Thank you, Mike Klausing&nbsp;------Original Message------This can definitely be done.&nbsp;Let's &nbsp;try the most elegant solution first. Locate that Quantity field on the source child record, and there will likely be a checkbox &nbsp;that says to treat blank as zero. Uncheck it.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

mikeklausing · Answer

I was able to mimic this action by using the following formula on a combined text field:&nbsp;var text CombinedText = ToText([Combined Text Window Size]);var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");// substitute new line for semicolonSearchAndReplace($RemoveSpaceAfterSemiColon,";","&lt;br&gt;")That makes it look like this:&nbsp;
This is exactly what I need to do with the original question as well where they have the option of having 4 total items in this list, but if not it doesnt leave blanks.
I still havent found the proper way to combine the fields&nbsp; if they are 3 seperate fields entirely.------------------------------Mike Klausing------------------------------

markshnier__you · Answer

List("
",and then list all your fields or expressions which might or might not be null)&nbsp;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. &nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

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
------------------------------

mikeklausing · Answer

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
------------------------------

Forum Discussion

Formula Rich text nested IF statement List

Related Content

Nested If formula

formula help "if statement"

Dynamic Rule - Or statement?

Jinja If statement equals field value

Nesting URL API Calls in one Button