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:
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.