Forum Discussion

GeoffBarrenger's avatar
GeoffBarrenger
Qrew Captain
5 years ago

Clear out all Data in a Field - without deleting the field itself

Hello, I feel as though I'm overlooking something very simple here. Is there any way to clear out all data in a specific field, without deleting the field itself?  Or even better - clear out al...
Tables and fields
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
5 years ago
Can you make a formula field with the parameters?

If([My Field] = true, [My Field], "")

This creates a mirrored field that is either blank or filled in depending on your parameters. Then every day or week or month run a table to table import overwriting that My field with the mirrored field.

------------------------------
Mike Tamoush
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
You can make a saved table to table copy to copy the table into itself MERGING on Record ID#, so no new records are created.  Create a dummy formula field call field called [Blank].

For the mapping, you will map the [Blank] field into the field you want cleared out.

Then you can either run the save T2T manually if you are the admin, or else make a formula URL button to run the API_RunImport.

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