# Multiple users data from Magic Text
**URL:** https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389
**Category:** Get Help
**Created:** [August 26, 2024, 8:47pm UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389 "2024-08-26T20:47:47Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Senuoy](https://forum.adalo.com/u/Senuoy)
#### Post date: [August 26, 2024, 8:47pm UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/1 "2024-08-26T20:47:47Z")
Brain fog here, sorry, but here is the scenario, I’ve created an AI chatbot that can interact with loaded database information through magic text.
So say the app has a teacher, that teacher has multiple students, in the magic text, how do I go load the teacher - Student names, emails, grades, and anything in their data.
I was successful in loading numerical staff related them, but not all their names for examples, anyway to do that ?
Thanks
---
### Author:  [@Victor](https://forum.adalo.com/u/Victor)
#### Post date: [August 26, 2024, 8:59pm UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/2 "2024-08-26T20:59:43Z")
Hi @Senuoy,
As one teacher has multiple students, you can access the records using a list (of students filtered by teacher).
If you’d like to combine information from multiple records in a collection, you need either to use a 3rd party tool like Make to get data from Adalo db and aggregate it, or use some kind of custom component which can do that, or use another backend like Xano and use functions there.
Best,
Victor.
---
### Author:  [@Senuoy](https://forum.adalo.com/u/Senuoy)
#### Post date: [August 27, 2024, 2:27pm UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/3 "2024-08-27T14:27:36Z")
Thank you, Victor, I like the idea of a custom component, but I ll explore the Make option first and try it, I appreciate it.
---
### Author:  [@Senuoy](https://forum.adalo.com/u/Senuoy)
#### Post date: [August 28, 2024, 12:38am UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/4 "2024-08-28T00:38:36Z")
Hi Victor, sorry to bother again, would you do it this way? or would there be a better way ? I love simplicity so I m trying to create it that way:
My AI component Chatbot gets its magic text from :
1. A simple text ( hidden ) component, with an action to Make to get an Adalo list of records and update another Adalo record id ( a new Collection just for that called AI info )
2. Then another hidden text component loading that AI info records through magic text, which is than loaded into the AI component.
What do you think?
Thanks
---
### Author:  [@Victor](https://forum.adalo.com/u/Victor)
#### Post date: [August 28, 2024, 7:54am UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/5 "2024-08-28T07:54:45Z")
Hi @Senuoy,
I’d do that as an explicit custom action call (say, on a button) and reply. As far as I understand, you need to select some records from the collection and have one combined string as a result. So custom action params should be a filter criteria, and return param is string.
Then, on Make side, you have a webhook + Adalo API call (filtered API call so that you don’t list all records and filter them later, there is a limit of 1000 records for GET ALL), then iterator + **text** aggregator (you iterate records and aggregate fields which you want).
As a result you’ll have an aggregated string, which you eventually can send back to Adalo in a webhook response.
Such Make scenario will consume only 5 Make operations per run and 1 Adalo action per execution. In your scenario, if we assume there are N records which correspond the criteria, it will consume 1 + N Make operations per run and 1+ N Adalo actions per execution.
Best,
Victor.
---
### Author:  [@Senuoy](https://forum.adalo.com/u/Senuoy)
#### Post date: [August 28, 2024, 3:14pm UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/6 "2024-08-28T15:14:43Z")
Thanks so much, Victor, I appreciate it.
---
### Author:  [@system](https://forum.adalo.com/u/system)
#### Post date: [September 7, 2024, 3:15pm UTC](https://forum.adalo.com/t/multiple-users-data-from-magic-text/49389/7 "2024-09-07T15:15:22Z")
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.