Hello, Thank you all in advance, your topics have been very helpful.
I am new to appsheet and I have a problem importing.
When I import a CSV that has some Rows already in the table. In theory, it updates them, but the fields that do not have information or data in the csv overwrite them with the initial value. even though these fields have values โโin the spreadsheet.
example:
Spreadsheet:
key | name | state (initial value: Ready)
111 | John | in progress
112 | Peter | Finalized
CSV file:
key | name
111 | Juan
112 | Pedro
113 | Jesus
Result after import:
key | name | state
111 | John | Ready
112 | Peter | Ready
113 | Jesus | Ready
How could I keep the information?
I already tried adding, to Column "STATE" in the CSV and leaving it blank, but it still overwrites it.
Please help me, Thank you very much.
PS: sorry for my english, use google translator.
Solved! Go to Solution.
Use a branch condition, or separate bots, for it the key exists already or not. In one, add a new record, in the other update the existing.
User | Count |
---|---|
19 | |
10 | |
7 | |
5 | |
5 |