Hi community,
I've been searching for this answer for days, so this community is my last resort. Thanks for reading and potentially helping me!
Apologies if this topic has already been covered; I haven't found it so far.
First, I have an Airtable database with two tables:
- Student
- Event
(this is for my guitar teacher, let's call him Ludovic)
The process is straightforward:
- A new student must complete a form, which populates the student table.
- Ludovic must complete a form to create events like “Friday jam” or “Wednesday theory,” etc.
⇒ Then, I use a script in Airtable to trigger a callin.io scenario, sending SMS to students via Twilio. Ludovic can send an invitation to:
- Everyone
- A specific group (we've agreed on beginner, intermediate, and advanced, but this might change)
- Only a few students, added manually.
Below, you can see the form:
And some further information:
- Who do you want to inform ⇒ Everyone | Group | Individually | Group + individually
- Level required ⇒ Beginner | Intermediate | Advanced
- Student ⇒ from the student table (creating a multiple linked record)
Some clarification on the second point. I can currently only send to one group at a time (using a single select field), and I'm working on using "multiple select" so we can send a message to two or more groups.
That being said, the trouble begins:
- Ludovic wants to send a message to groups and add (or remove) specific students.
So, the scenario at the bottom is my latest attempt to achieve this:
-
The webhook sends the event information.
- The output provides an array of manually added students.
-
I'm using a filter to only include students with the desired playing level.
- I'm using Airtable's "Get a record" module to retrieve information on students by their ID.
- Before this, I need to use an Iterator because if I don't, "Get a record" can only process one student.
- Then, I'm using an Array Aggregator to re-aggregate the students, but this is performing two operations, and that's my problem!
- After searching for solutions, it appears the answer is to use an Aggregator and "close the loop," but it's still resulting in two operations.
- And at the end, I'm using a "Search records" module to get information about:
- To summarize, I have students with the matching level directly from the student tab (Search records).
-
And I have students from the event table, which are multiple linked records.
- My goal is to aggregate everything into a single array and then send my message.
Please let me know if you require further information; I'd be happy to provide it.
PS: I apologize if this is difficult to read; I am not a native English speaker.
Welcome to the callin.io community!
You haven't provided enough information yet to demonstrate the issue, which would allow us to reproduce the scenario and any errors.
To enable others to assist you with your scenario, please provide the following:
1. Relevant Screenshots
Could you please share screenshots of your entire scenario? Also, include screenshots of any error messages, module settings (fields), relevant filter settings (conditions), and module output bundles. We need to see your setup to offer the best advice.
You can upload images here using the Upload icon in the text editor:
We would appreciate it if you could upload screenshots directly here rather than linking to them externally. This allows us to zoom in when images are clicked and prevents tracking cookies from third-party sites.
2. Scenario Blueprint
Please export your scenario blueprint. Providing your scenario blueprint file will allow others to quickly recreate your setup and see how you've configured the mappings in each module. It also enables us to take screenshots or provide module exports of any solutions we develop for you, which you can then easily paste back into your scenario editor!
To export your scenario blueprint, click the three dots at the bottom of the editor and select ‘Export Blueprint’.
You can upload the file here by clicking this button:
3. Output Bundles of Modules
Please provide the output bundles for each relevant module by running the scenario (you can also retrieve these without re-running your scenario from the History tab).
Click on the white speech bubbles in the top-right of each module and select “Download input/output bundles”.
A. Upload as a Text File
Save the contents of each bundle in a plain text editor (without formatting) as a bundle.txt
file.
You can upload the file here by clicking this button:
B. Insert as Formatted Code Block
If you are unable to upload files on this forum, you can alternatively paste the formatted bundles. These are the two methods to format text so it won't be altered by the forum:
-
Method 1: Type code block manually
Add three backticks
```
before and after the content/bundle, like this:```
content goes here
``` -
Method 2. Highlight and click the format button in the editor
Providing the input/output bundles will allow others to replicate your scenario's behavior, especially with complex data structures (nested arrays and collections) or when external services are involved.
Sharing these details will make it easier for others to assist you.