Forum Discussion

VivekVishwanat2's avatar
VivekVishwanat2
Qrew Cadet
6 years ago

Update a field the previous records

Hi, I have a table, say it has 3 fields; Name, Date, Status.

Status can take two Values Active/InActive

Whenever a new record added, I need the status of all previous records should be changed to InActive.


Any idea to deal with this situation?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    You should be able to use an Automation for this. They can edit up to 1,000 records.