This is continued in the content below.
This time, I’m going to send an email to the person who initially left an opinion through Typeform when the comment was posted.
I use2 different tables now, so I need a connection to bring the email of the questioner who left the first comment.
(It’s like Excel’s vlookup)
In Airtable, each row in the table has its own ID value.
Through that value, we will get the value of the other table.
In the RecordId field, right-click to edit.
Click Edit field and select Link to another record.
Select the table where comments are left (Table 1) and click Save.
In the Add lookup field, select the ‘이메일(email)’ you want to import.
After saving, the value of RecordId may change.
The reason is that we get the first row of the connected table.
In order to make the value of RecordId appear well again, I’ll change the first row of the first table(Table 1) to RecordId
Go to the first table(Table 1) and add fields.
The type of field is Formula, and put the record_id() value in the space below.
Then a field with the Record Id visible would have been added.
Now drag to the first row.
Then go to the ‘Table — Comment’ Table.
I can see that the record value comes out well again.
And It can be added well even if I leave a comment again.
I will now work on it so that I can send you an email.
First, go to Automations for the call.
There are many triggers to choose from here, and I choose ‘When a record is created’.
And when it comes up as a record in ‘Table-Comment’, modify the value so that it works.
Next, add sending mail.
Send mail, which is given as the default, is a suitable option for sending to some kind of administrator.
That’s why I chose to send Gmail.
If you modify the configuration properly, you will receive an email.
