High Level: I am creating a list of items to rent, each with 5 fields worth of relevant information that I expect to change regularly, so I want to be able to pull/update the data from a CSV/API/something else so I’m not continually having to update the website. I figure the best way to do so would be with a repeating group, but am struggling to figure out how to map the following fields to it.
The fields types I need pulled are:
Picture of item
Text
Text
Text
Text
Advice on where to pull this information from and how to set it up thru bubble would be much appreciated.
@emmanuel Maybe my understanding of blockspring is incorrect, but doesn’t blockspring pull information from different parts of the internet and save that info on a regimented schedule? What I’m trying to upload is data where I’m the only person that will have it. I guess I could upload it somewhere in the internet, I just dont know where I would need to upload it to to have blockspring pull it.
Also with that, I’m not finding how to map multiple fields at once/blockspring or not – it seems you can only upload a csv and map to a single field – not the five at once that I want to do.
Look into hooking up Blockspring with Import.io. Those two together should let you scrape data that you may need and access it through Bubble. More details would definitely help. PM someone if it’s a bit more private.
I am not sure import.io is the way to go (much as I love import.io). The way to do it would be to have a google sheet with your data on it, then use blockspring’s Query Google Sheets function to import the data. All your data would be in a Google Sheet, so you can update. And you need to set it to sharable, then configure the plugin.
This allows you to map the fields in the query to the header values, so you can select the field with Bubble.
Here I am using the Query Google Spreadsheet function, and have removed the “where” clause so I get everything.
You could potentially use the “Read Worksheet” function instead.
There are currently some weird things that happen with this (like having to have a field formatted as a number). But once you get it running it is easier than the native CSV import.
Thanks @NigelG , this is exactly the concept I suspected existed. A few last questions…
I’ve been able to map everything I believe how you suggested, however, I’m not seeing the data show up when I go to preview. Is this because you have to fully launch the website to a domain before that data will be pulled from blockspring/google sheets?
Also because I can’t see it, I’m not sure if I mapped the images I want shown correctly of the vehicles – I’ve attached screenshots of everything below. Please let me know if this correct.
@NigelG Yeah I’ve set up both the “Max # of Occupants” and “Price per hour” as numeric, the picture of bus as an image (tried as text too still didn’t work), and the special features as text.
I’ve played with the google spreadsheet sharing, but not sure what else to fiddle with that would change it.
