Skip to main content
Question

Toggle Checkbox for Whole Table

  • February 3, 2021
  • 0 replies
  • 33 views
Hi All,

What's the best way to set a value on every record in a table? Best solution would be something I could call with the API, OK solution would be something scheduled, unacceptable is anything manual.

Workflow/Use Case
  1. Flip all records in the table to Exists=False (Exists is a checkbox field)
  2. Load (POST to /records endpoint) my data from an external system, each record has Exists=True
  3. Now any records which weren't in the last load are still marked Exists=False
  4. Profit. Or at least have an accurate representation of the current state of the other system.

Thanks,
CD

------------------------------
Chris Dyroff
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
The easiest way to mass update our records and the table is to create a saved a table to table import where are you map the records into themselves based on matching record ID and just update the single field with the formula field which is a checkbox field with the formula of false.

This can be put into a URL formula button that the user presses or this could be run on an overnight scheduled automation.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement