With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, February 1, 2018
yogi_Pull Multiple Entries From Form Reponses Sheet Entered Together In Rows
I've been looking for a way to import user Google Forms responses into my database automatically, however the problem I've run into is that I have a lot of repeating blank column due to repeating sections.
I would like for the Form Responses to be pasted into the correct row when the RMA number given in the Please enter your provided RMA reference section matches the row in MainData sheet, returning the relevant company, customer, device type, serial, site and fault reported fields.
However I've been struggling with achieving this with QUERY as I cannot edit things the next row below, or make it loop, so that if fills in Yes to another RMA reference, the same contact details get added to the row below.
I've thought of using INDEX and MATCH but I have no idea where to start! Here's a sample sheet: