S
S
SHT2020-01-14 09:10:23
Google Sheets
SHT, 2020-01-14 09:10:23

How to add rows manually to a sheet where QUERY is already output from another sheet?

Applications are accepted in two ways: through GOOGLE FORM and manually.
After receiving through GOOGLE FORM, applications under a certain condition are selected using QUERY and transferred to another Sheet. On the same Sheet, I would like to add lines with applications manually, so that later I can carry out subsequent processing.
Is such an implementation possible?
PS: That is, 10 applications were accepted through the google form, they were transferred to the List with the help of a query. The eleventh (11th) line on the same Sheet inserted the application manually. Further, when applications are received through the google form, they will be added in the 12th, 13th lines, and so on.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-01-14
@SHT

I would like to draw attention to the Principle of separation of functionality (in tabular p...
You write

then carry out further processing

Excuse me, "later", when is that?
According to the PRP, you must have a Table of Making Content:
  1. Sheet/Sheets for receiving answers Forms/Forms
  2. Sheet/Sheets for manual data entry
  3. Sheet/Sheets for intermediate data processing with or without consolidation
  4. Sheet/Sheets to display processed data with or without consolidation

Consolidation in this sense means combining data through range notation { }or using scripts.
Detailed description of how ranges can be combined How to union ranges in google spreadsheets

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question