More control over csv import action

[dbaum]

It would be helpful for app creators to have more options within the App: import a CSV file for this view action to control the actions behavior. This would help avoid user errors and even inappropriate (whether malicious or unintentional) revisions to existing rows or population of columns intended to be excluded from the import. For example:

1. A property that governs whether the action will only add rows, only update existing rows, or both (e.g., so I can prevent users from editing existing rows)
2. A property that governs which columns will be imported from the .csv file (e.g., so I can prevent users from including columns I don't want populated via import)
3. Properties that govern mapping from .csv file column headers to column names in the AppSheet table (e.g., so I can give users a template with user-friendly column headers that map to column names within the app)

[Joseph_Seddik]

Nice!

[dbaum]

I've encountered another reason this is needed. I created a csv import action for a table that allows Adds but not Updates. However, the action won't appear for the table's views unless I also permit Updates.

Even without the types of configurable properties noted in the original feature suggestion, ideally the action would be available for tables that allow only Adds or only Updates and then process the csv file only if it correspondingly includes only new rows or only revisions to existing rows.

[KingsGuava]

Allowing us to rename the required header column in the CSV so that they can be mapped to non-user friendly column names would be really helpful! Our database column names can be quite verbose to describe the relationships and our users only want to see the columns they're used to in the app.

[takuya_miyai]

@dbaum 

I think it is a Great Idea.👍
With more options for Import actions, we can create apps with a better UX.
The first thing I would like to see is an option to not update if null. In the Salesforce import tool, Dataloader, this is accomplished by toggling the "Insert null value" setting.

@Roderick 
I will note the related Feature request.

https://www.googlecloudcommunity.com/gc/Feature-Ideas/Only-Update-Specified-Columns-with-CSV-Import/...
https://www.googlecloudcommunity.com/gc/Feature-Ideas/Exclude-a-Column-from-Updating-in-CSV-Import/i...