Automatically add row in table

[snerdya]

Hi. Is it possible to add row to a table when it satisfies a certain duration? For example, I have table Name list and table Reserve name. The name column in table Reserve name is ref to table Name list and this name will be reserved for a week. What i want to do is when the reservation time is expired, the name will automatically added back to the name list. I really hope there is a way to do this. Thank you 🙂

[SkrOYC]

It's weird that you want to duplicate a certain record, generally you just write an expression that makes it unavailable until a certain period of time, but don't duplicate after it.
Could you show us your whole setup?

[Steve]

Add a column to the Reserve name table named (e.g.) when of type DateTime that contains the DateTime when the entry was added, With that, you can decide whether the reservation is still in effect.

SELECT(
  Reserve name[name],
  (TODAY() <= ([when] + "168:00:00")
)

Where 168:00:00 is 7 days.

The list of available names:

(
  Name list[name]
  - SELECT(
    Reserve name[name],
    (TODAY() <= ([when] + "168:00:00")
  )
)