RG from 2 datasets

zatrix.za · 2024-09-29T15:36:09.851Z

Hi fellow bubblers!

Consider this scenario: I have an RG, that I want to display content (tasks) from 2 tables, let’s say personal and bisiness. That in itself is achieved with merge in the search parameters and works fine.

How would I go differentiating between 2 data sources? For example displaying a different icon in the row, based on where the data came from. Can this be achieved via row conditional formatting somehow, or is the only option is to actually add an icon field in respective datasets?

boston85719 · 2024-09-29T16:48:53.640Z

zatrix.za:

I have an RG, that I want to display content (tasks) from 2 tables, let’s say personal and bisiness. That in itself is achieved with merge in the search parameters and works fine.

If you are not setting your RG to type of content of Text, then you are not merging two different data types, and are instead just merging two different searches for the same data type. Without knowing exactly how you set things up, I will assume you are just merging two different searches of the same data type and that the data type has a data field that is called ‘Type’ (idk) and has two potential values of personal or bisiness. I’d imagine your first search is constraining by the field ‘Type’ and value of personal, while your second search is constrained by value of bisiness.

zatrix.za:

How would I go differentiating between 2 data sources? For example displaying a different icon in the row, based on where the data came from. Can this be achieved via row conditional formatting somehow

If my assumption is correct on how this is setup for the datasource of the RG, then put a conditional onto the icon based on the current cells’ things ‘Type’ and change the icon how you want it for the two different ‘Types’…this may be two separate conditionals where current cells type is personal and a second conditional of current cells type is bisiness.

zatrix.za · 2024-09-29T19:16:00.089Z

The RG is indeed setup as just text, see the screenshot.
RG_setup

Each cell is displaying a task or file name respectively, sorted by date.
RG_display

boston85719 · 2024-09-30T04:28:37.081Z

zatrix.za:

The RG is indeed setup as just text

Okay…Create two separate RGs or custom states to hold onto the two separate lists as text (not the ToDo or ClientFiles things) and for each one format as text but create your own type of system to separate necessary values. From the looks of it, you need the Name for both data types.

Search for ToDos: format as text - format as text with something like ToDo | This ToDo Name
Do the same for ClientFiles
Take the two different RG or custom state list of texts formatted and merge those into your RG to display
In text element use current cells text split by | item #2
In Icon use condition current cells text split by | item #1 is ToDo (have a second condition for the ClientFile)

zatrix.za · 2024-09-30T12:21:22.162Z

Thanks, sounds like a plan, will try that!

system · 2024-12-08T15:36:42.130Z

This topic was automatically closed after 70 days. New replies are no longer allowed.