How to display 2 lists with different data types in repeating group?

Need help
1

I have a Data Field called ‘DirectReports’ which contains a list of numbers (Child IDs) and a list of texts (Child Names) like shown below:

image

I would like to present them in a repeating group such that each student name and their ID are displayed separately in each row. However, I am struggling to do this and instead I just get the whole list on each row like below:

image

Any suggestions are greatly appreciated.

2

This can be done the way you set it up but the DB scheme is not set up properly. You should have a directReports dataset / table and in it a childId and childName field.

3

Thanks @code-escapee. I am not sure I follow - when you say ‘DB scheme’ do you mean changing the database table?

For some context, this is my directReports table I am already using:

image
image1660×478 63.4 KB

Thanks

4

What I don’t understand is how to actually include 2 lists of different data type in the one RG

5

Yes I do. That’s the first Step. Especially since you have emails as well. As you see, instead of 3 lists in DirectReports, it should be one a child that has those 3 fields. This is very basic, and you should learn the fundamentals before continuing to work on your app. It’s not as fun but it will save you hours and hours of torture and headache.

6

Okay, so if I understand you, you’re saying to just use a regular database without the use of lists? This way all fields are one-to-one.

I use this structure in plenty of other tables, but what I was experimenting with is how to do this using lists to save on creating multiple entries for each teacher (if you follow the logic - there are multiple students per teacher).

If this approach is not appropriate, then I’m interested to know when a list should be used in a database? Because it seems as though it creates more of a headache than anything else, like you mentioned.

Cheers

7

@pattokane Just wondering if you had any thoughts on this one?

8

From the looks of this (with out changing too much) you could just attach the student to that dataType as a field and then pull the student.

You could then have a the students name, email and ID 's all come through in a different rows.

Would be happy to jump in @jackwemery93 and give you a hand setting it up :slight_smile:

9

Also, a text RPG inside those section might do the trick

10

You’re a legend Patto. Appreicate it :slight_smile:

If you’re happy to, it would be a huge help if we could do a call.

Thanks again for your help!

11

That is not what I’m saying. Lists are a critical part of an DB. Just because something is a list doesn’t mean it has to be broken into different fields and have a list of each field. Consider: How would you link Child Id 9 to Beth Ranger? Sure you can use index 0 fo each array but if anything gets sorted or modified you’re in a huge mess…

Lists/Arrays are critical for a robust Database

So yes USE Lists but don't create lists of multiple fields that are linked to each other; instead, create a list of records that contain all those fields.

See the DB diagram below. The top table shows how you are doing it. The bottom tables are how it should be done. You should be able to see how much cleaner and easier it is to manage and determine relationships between the child’s data (i.e., their name and email).

image
image605×645 7.79 KB

1 Like
12

Thank you so much @code-escapee and apologies for my rookie questions. This is a really big help for me. Appreciate it a lot!

13

You are welcome, and there is nothing to apologize for. Before creating screens and workflows, make sure the fundamentals are solid.