Hi Currently I am using Read worksheet option to view the data in bubble from the google worksheet. However keen to know if I can use the same option for reading one more worksheet. Currently I am unable to figure out the way. is there any way I can use “Read worksheet” option of Blockspring twi…

Try merging 2 Read Worksheets as the data source. You’ll be able to individually define spreadsheets AND worksheets within:[image]

@romanmg Thanks Gaby. Will this logic work for the below scenario? Read worksheet --> Google Sheet1 --> Fields/headers (Eg: Sales,cost,Items) Read worksheet–> Google Sheet2 --> Fields/headers (Eg:Staff Name,Contact etc.) In the above case, Sheet 1 and 2 are not related to each other and their f…

Hm, good question. I’d need to test this because I wonder if you even need to update the plugin since you can just edit the sheet ID in the dynamic area in the repeating group. Try this and see if you get sheet 2’s headers as options in addition to sheet 1’s headers. I’d definitely need to test tho…

Did not work for me. You have to “initialize” Blockspring API call to work with each sheet, and if you have two sheets, when you try to “initialize”, it overwrites the data from the first one. So currently you can work with a spreadsheet with 1 sheet only, which does not look to good actually (tak…

I’ll create a post on this in Bugs section to validate that.

[image] Blockspring - Working with 2 Worksheets\Spreadsheets Bugs hi Bubblers, Coming from this topic: Ran into an issue when I see that I can only use Blockspring with 1 worksheet of 1 spreadsheet to read the data. If I need to query data from 2 worksheets of the same…

Can I use "Read worksheet" option of Blockspring twice for 2 Different sheets?

Questions

vladlarin January 23, 2017, 12:43pm 7

Topic		Replies	Views
Blockspring - Working with 2 Worksheets\Spreadsheets Bugs	0	790	January 23, 2017
Adding multiple Google Sheets Blockspring blocks Need help	3	854	May 21, 2017
Blockspring read spreadsheet problem Need help	14	1960	April 26, 2017
Blockspring / Google Sheets Integration Error Need help	15	2050	December 20, 2015
BlockSpring Help Need help	47	5938	April 29, 2017

Can I use "Read worksheet" option of Blockspring twice for 2 Different sheets?

Related topics