Question: How to selectively (yet automatically) sync rows based on user input?
Details: I want users to be able to โtestโ the app by entering data during training.
So I added a field/question that letโs the user indicate if the data they are entering is โtestโ or โactualโ data.
Initially, I merely filtered out the โtestโ data, but then I have many rows of data that I have to exclude from analysis.
So then I decided to add an action that โDeletesโ any โtestโ rows after saving.
Now the back-end only contains โgoodโ data and no filter is needed.
Howeverโฆ
I get many, many blank rows were the โtestโ data was synchronized and then deleted.
So is there a way to make synchronization contingent upon a certain value in my โTestโ column?
Or is there a better solution for managing โtestโ data?
Sync is not programmable. If you are using Gsheets, you can use Google apps script to write a script that manages your test data.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |