Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Auto create record of when a Record was used

Topic Labels: Scripting extentions
285 2
Showing results for 
Search instead for 
Did you mean: 

I have a table of Items and a table called Used, that has just a date time field and a link to Items.
In a grid view of Items, when I click a checkbox it should create a Used record for that Item, with date set to now.
I also need a way of clearing the checkboxes for all Items, leaving the Used records as they were.
I guess I need 2 scripts? What would they look like? TIA.

2 Replies 2

Welcome to the Airtable community!

What you want could be accomplished with two scripts. It is also possible with automations and no scripts.

If you are trying to write the scripts yourself, please post what you have so far and where you are getting stuck.

If you do not want to write the code yourself, are you looking for someone to write the code for free, or do you have budget to hire someone to write the code for you?

Thanks. I hadn’t looked at automations.