RG from 2 datasets

[zatrix.za]

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]

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

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

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

[boston85719]

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

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

[zatrix.za]

Thanks, sounds like a plan, will try that!