Pipelines | unique | list
Hello,
I have a parent table and a child table I am working with.
The parent table has a field called [CList Master (Pipeline generated)]
The child table has a field called [Clist current page...
Forum Discussion
I just tested the summary combined text relationship field called [Combined Text Clist current page] (viewable in screenshot above). I assumed it had a max amount of 20 for some reason, but after testing it doesn't seem to have a limit? If this is accurate, maybe it would be easier to create a formula field and have it list out all unique values from this [Combined Text Clist current page] on the parent table? Just a thought
------------------------------
Shane Miller
------------------------------
Are you just trying to combine the list of clist entries into a combined string? Or do you need to parse out uniqueness within it as well. The summary combined text list field is not capped at 20 - I believe it does cap out somewhere over 100 but I forget the exact limit. If you have concerns with that cap, you can use formula queries instead which do not have a the same limitation and will typically show all entries without any cap.
------------------------------
Chayce Duncan
------------------------------Hey Chayce,
Thank you for responding. The child records may go over 100, so I was trying to create a "fool proof" system using pipelines. Essentially, I am trying to create a clist for an embedded report so that the embedded report only shows columns which have data in the child records. Formula queries may work at first, but I expect hundreds of thousands of records on the child table, so I don't think it will be efficient long term.
Does that make sense?
As an example:
child record ID 1 may say: [Clist current page] = 1.5.17.34child record ID 2 may say: [Clist current page] = 5.18.34
I would need a field on the parent table to then show the values: 1.5.17.18.34Samuel Trachy gave me the idea during one of the office hours. He helped me get the embedded report working with a clist, and then recommended making a dynamic field which houses the unique clist on the parent table
------------------------------
Shane Miller
------------------------------- MarkShnier__You
Qrew Legend
The limit is 150 unique children rolled up to a combined text field.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
