Create record in linked table with checkbox

[Damon_Talbot]

Destiny Search Project ran another large search yesterday using Airtable with over 100 volunteers. So now that we have used some of the new features and formulas in a full search operation we already are thinking of improvements.

One thing that may improve or workflow and ease of use for volunteers that assist in our registration process would be to have our “Check In / Out” table populate a new record with a “Time In” field filled with the current time when the search volunteer is marked as “Verified” in the “Volunteers” table.

The reason we need a separate table for Check In / Out instead of just in the Volunteers is sometimes we have people come and go or may run for multiple days resulting in several different periods of time per each volunteer.

I am wondering if there is some type of formula that could be used to make this work.

Thanks again to Airtable and the community here for making our system possible!

[Tuur]

Populating another table automagically isn’t possible with Airtable. With Zapier you could set this up.

Also your ‘Time In’ field is probably the created time of the new record so you could display that with a very simple formula:

CREATED_TIME()

[Damon_Talbot]

We found a workaround that will suit our needs. What we did was create the verification and check in a form in the Check-In/Out table instead of the Volunteers. This way it gets the time added as needed and still links back to a volunteers record correctly.

[Tuur]

Just in case you’ve missed it: created time is now a default field type too.

[Damon_Talbot]

Yes, however, the volunteer is not always checked in right when the record is created so would not have worked in our case.