Many DataSources require frequent editing. For instance, suppose you have a DataSource containing a list of customer names, addresses, and phone numbers. As you get new customers and lose some old ones, you will want to add or remove some of these customer records. If a customer moves to a different location or changes their phone number, you will want to edit the records. This article goes over how to do all of these things. In particular, we cover:
- Adding/Editing DataSource records individually
- Adding/Editing DataSource records in bulk
- Deleting DataSource records
- Indexing your DataSource
All of these actions can be done in the DataSource Editor. To access this screen, first open the DataSources List by selecting Manage Data Sources from the More dropdown, then click the name of the DataSource you wish to edit.
You will see a list of your data source records, with the first column always designated as “Key”. Note that if your DataSource has many columns, they might not fit on the screen all at once; scroll right to see these additional columns.
To edit an existing record, simply find that record on the page and click it. The record will immediately become editable, as shown below. Update the record with new values and click Save.
creating a new DataSource.
- If the Key column value in the CSV matches an existing Key in the DataSource, then the existing record will be updated with new column values from the CSV.
- If the Key column value in the CSV does not match an existing Key in the DataSource, then a new record will be created.
- If your CSV file has a header row, check the CSV file has header row box. If this box is checked and your DataSource has default column names, the header row will be used to update the column names. If it is not checked — or if your DataSource already has non-default column names — then column names will remain as they are.
- If you wish to be able to use this DataSource when your mobile device is offline, check the Use Datasource Offline box. Database fields connected to your DataSource will now work properly even when you fill out a form while your mobile device is offline.
See here for more on what this means.
To index a DataSource column, click the Set Indexes button at the top. You will see a dialog box listing all your column names with checkboxes next to them. Check the boxes next to the columns you want to index. You can index up to 5 columns in addition to the Key column, which is always indexed automatically.