Hey, guys. I’m trying to create a management solution for Telegram groups for our company. We are currently using Airtable for an employee directory, and I would like to incorporate messaging group management into it. We have several Telegram groups at our company, and each employee is granted membership to the groups based on their role at the company (sales, engineering, etc.) I would like to use an automation to:
I’m planning to use Airtable automations to invite the new users, and a chat bot to kick/ban members that have changed roles or are terminated. (probably this one: Telegram Bot Integrations | Integromat)
I’m struggling with coming up with a “clean” way to make this work. Ideally, there would be a linked field to another table that contains all the info for the various groups (name, invite link, etc). Users should be added/removed from groups by changing the values of the linked field. I can set up an automation to watch when that field is updated, but I can’t think of a good way to see exactly how the field has changed.
A “dirty” way to do this is to create a checkbox field to specify group membership, but this will get messy very quickly. There would have to be a separate checkbox for each group, and a separate automation for each checkbox.
Have any of you solved a similar problem? I would love some suggestions.
Thanks. This is good advice.
Junction tables specifically is a new concept for me. I have to dive deeper into it to wrap my mind around how the automations would need to be set up, but I think this is the right solution.