Integrate Airtable with Integromat

[ryancwalsh]

https://www.integromat.com/scenario/2983577/edit currently posts to https://near-certification-tools-tpq1.onrender.com/api/mint-cert (and will be updated once production is ready https://github.com/NEAR-Edu/near-certification-tools/issues/34#issuecomment-1057283030).

https://airtable.com/appJ2JBZMozcfGtOb/tblWzeCYH9FPHlqP0/viwBuvxeeFtHy3GYA?blocks=hide needs to somehow get connected to Integromat (but maybe not directly, if we want to add some kind of secure form step, or something... since Sherif said maybe we'd want instructors to need to use their NEAR account to "sign" when issuing a certificate).

[ryancwalsh]

See related: https://trello.com/c/Ei60zZkO/15-replace-or-clean-up-airtable

[ryancwalsh]

@petarvujovic98 I already have this Integromat app at https://www.integromat.com/scenario/2983577/edit that I setup weeks ago:

But what I need to know how to do is replace those dummy strings with variables that pull in from Airtable.

Or I'd even be open to having a totally independent form or Google Sheet or something, since currently we're talking about <100 people that we owe certs to.

I won't want to run across all rows of https://github.com/NEAR-Edu/near-certification-tools/issues/46 all at once. I'll want the ability to choose (maybe via some new field) a handful of students to be included in a batch, and then it should iterate over just that batch, issuing certs (and eventually we'll also want it to email the student, but that can be manual for now).

I was trying to get this deployed today, but clearly that's not happening. Still, I want to get this project finished ASAP. We're nearly there.

[ryancwalsh]

@petarvujovic98 We now have in Airtable:

• nc-instructors (Sherif has not yet confirmed that sherif.near is accurate, and I definitely want his confirmation before we issue certs)
• certificate-batches I edited this a bit. Now it uses the Autonumber field type, which I named Batch ID. Then Batch ID is what gets pulled into the next table as a foreign key.
• nc-submissions, filtered You'll also notice that now the instructors' mainnet gets pulled in as a linked column.

[ryancwalsh]

I'll mark this as closed since we're already talking about everything over in https://github.com/NEAR-Edu/near-certification-tools/issues/46