Answer the question
In order to leave comments, you need to log in
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
I would like to draw attention to the Principle of separation of functionality (in tabular p...
You write
then carry out further processing
{ }
or using scripts. Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question