When you clear a Global Data Table, you wipe one or more values from specific rows within it. This action is useful if you want to ensure that certain entries exist but no longer contain certain data. For example, if a store is currently changing their phone number, you might want to wipe the Global Data Table entry until they have a new number. This way, Agillic doesn't show the wrong number as they're changing it.
This is different from deleting a Global Data Table entry where the entire entry will disappear from the table. When clearing Global Data Table entries, the entries will still exist but with some or all the fields blanked out apart from the ID.
There are three ways to clear a Global Data Table:
- How to Manually Clear Global Data Fields
- How to Clear Global Data Table Fields with Import File
- How to Clear Global Data Table Fields with API Calls
How to Manually Clear Global Data Fields
To manually edit or clear your Global Data Tables in the interface, you have to change some of your Agillic settings. Go into the Settings module and then the subsection 'System Settings'. Then click 'Global Data Tables' and check the box in the main portion of the screen.
- Log into Production.
- Open the Data module.
- Open the 'Global Data' section.
- Open the 'Global Data Table' folder.
- Navigate to your Global Data Table.
- Open the Global Data Table.
- Open the 'Global Data Table Editor' panel.
- Doubleclick on the entry you want to clear.
- Delete the value for one or more fields.
- Click the 'Save' button.
You've now cleared a Global Data Table field.
A Global Data Table with no value in the phone number field for the Paris entry
How to Clear Global Data Table Fields with Import File
To clear Global Data Table fields with an import file, create an import file in the Global Data Table format which contains blank values for the fields you wish to clear. When importing blank fields to the Global Data table, the existing value in the data field will be overwritten with the blank value.
How to Clear Global Data Table Fields with API Calls
You can also choose to clear your Global Data Table fields by using API calls. You can read more about the set up as well as how to make the API calls in our Developers Documentation here.