I've been watching the protests unfold and I see a lot of police brutality from videos and descriptions people have shared online. I found a GitHub where all of this is collected and I want to use that data to make a site where people can report/try and solve issues together.

My question is:

How to I combine the imported JSON file from GitHub, with the Google Form data I will be collecting on the site?

I have 3 tabs set up:

Main is going to be the consolidated tab, where data from the other two are going to be funnelled into.

PB GitHub is the JSON data being pulled in (with Google script). I want to selectively pick columns to put into the Main tab.

User Submitted is the Google Forms data, also to be funnelled into the Main tab.

I tried something like this: ​=query({ImportJSON("https://raw.githubusercontent.com/2020PB/police-brutality/data_build/all-locations.json");ArrayFormula(User Submitted'!B2:J)})
Where I put them one on top of the other on the spreadsheet. The problem with this is that the columns have to match for it to output data. I think I might have to run another Google script but I'm not sure what to do. If anyone can help or point me in the right direction, I would be super grateful.

Reference: https://docs.google.com/spreadsheets/d/1OTei1GNpKc6ChyZbt4MxbnkmRYTnV3sHKluU23-DKh8/edit?usp=sharing

  • 1
    Welcome to Web Applications. Please add a brief description of your search/research efforts regarding running "another Google script" as is suggested in How to Ask. – Rubén Jun 9 '20 at 18:20
  • Welcome. The problem with this is that the columns have to match for it to output data Quite right, and at the moment you have two sets of completely dissimilar data. In order for us to help, please create some Form data, take a sample of some JSON data, and use them to (manually) create an example on "Main" of a successful outcome. On a tangent, you refer to another Google script - that implies that you are already using one or more scripts; please elaborate on this. – Tedinoz Jun 20 '20 at 9:50
  • Did you resolve your problem, or are you still looking for assistance? – Tedinoz Aug 15 '20 at 1:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.