I would like to use Google Sheets as a form to query for data, select and store the data I'm interested in.
Below what I'd like to try. Please let me know if feasible, and if so, could you tell how to?
Automatically pull data I can do this, I can query an external API. Say data is imported in column A.
Once data is pulled, I want to select only the cells I'm interested in. How could I? Possible to create a tick option, say in column B, for each imported element ?
The selected cells should be automatically appended to another column - say column C. This is the part I'd like to know if allowed by Google Sheet: I need to associate a function to a tick, to append data on a column, but I also need to persist that appended data.
Example, if I run another query at point 1 and column A is updated, I don't want elements in C to be replaced.
The thing could be of course done with a web site, but wonder if I could mimic a web app for productivity.
I import data on column A. I can create tickboxes in column B : how to bind them to rows in column A ? (pseudo code for column B: IF( ISTICKED(B1), A1, ISBLANK(TRUE)) )
I want to have cells in column C copied "by value" from column B and appended, I mean if I change column A, still column C kept former results, while if I am changing selections on column B, I can see changes in column C.