Auto create record of when a Record was used

[PeterB]

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.

[kuovonne]

Welcome to the Airtable community!

PeterB:

I guess I need 2 scripts?

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

PeterB:

What would they look like?

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?

[PeterB]

Thanks. I hadn’t looked at automations.