Templates Plugins Courses

Google Sheets (service) by Jarrad


#1

Hi, @jarrad , @levon any chance you could come back to me before the weekend?

I replied to an email that appears to have sorted the date, but the numbers (and perhaps other formats) still have the non-defined value issue as per screenshot when trying to get them back from Sheets.

Thanks, R.3e8e60d648690a48cc39cdc69f70f8c266582585_1_690x439


#2

@jarrad , @levon

Also, I’ve noticed this issue a few times. Some (but not all - notice the last date Date P End (X for Y) is in the correct desired format) dates are formatted weirdly. As if in a different language. Consequently, the rest of the formulas that use these dates break.

Do you know what it is? Why? How to prevent?9b4fccb3f448753cf511fdae9851397e070ed279_1_689x403


#3

@levon @jarrad Date issue happened again. Note this time it was the Date P End (X for Y) that’s incorrect and causing formulas in the rest of the sheet to break.

Let me know, please.

It would be great if you could get back to me on my previous messages and posts, or at least a timeline of when you might.

Many thanks, Richard.


#4

@levon, @jarrad

Happened again. Think it pushes dates in different languages when other calls are queued before it. Hope you can solve along with the ability to call numbers and strings back to Bubble.

I’m trying to work out a way of correcting in Google Sheets if it happens but not there yet and not ideal.

Thanks in advance.

Please let me know.


#5

@Levon @Jarrad

Have narrowed it down to it being French for some reason. Although it may differ each instance.

Although when it pushes Dec it pushes it as Dic which may Sheets way of displaying déc which is the French abbreviation for December.

Also the ‘foreign’ values are being formatted automatically by Google Sheets whereas the one correct value (December in this instance) are not formatted by Sheets.


Let me know.

Thanks, R.


#6

Hi Richard,
Please accept our appologises that we kept you waiting so long.
The plugins from Jarrad are still quiet new for us, and we need some time, to understand theirs functions properly.
The way that bubble uses to format data, depends on the user settings on each individual PC. So some of your users may be located in France or having french copy of operating system, which makes theirs dates saved in own language.
In your case think will be enough to send the date formatted as “mm/dd/yy hh:MM tt” (with the month formatted as number), and than use google sheet to display it as text.


#7


#8

Thanks for coming back to me Karel. That’s not it actually as I’m the only user. The app is still in dev.

For the moment I’ve got a workaround in Sheets to reformat dates (using a VLOOKUP) however they show up from the plugin from Bubble.

In terms of priority, Jarrad was almost finished with the Google Sheets (service) that he was developing. It brings dates back ok, but Bubble won’t let the Get number or Get string call work because it says the data is undefined.

All the info is on Zeroqode forum posts I’ve added to.

I can’t move my app forward without the Google Sheets (service) plug in being able to retrieve numbers and strings in the same way it successfully retrieves dates.

I was discussing with Jarrad the development of some custom function for what I’m achieving (but not able to fully retrieve) by spreadsheet calculation in Sheets.

Would I talk to zeroqode about that now or Jarrad (although Jarrad isn’t responding to me at the moment).

Let me know please.

I’m a little in limbo.

Many, thanks, Richard.


#9

hello Richard,
sorry it’s taking so long for us to help you with this, we are a bit overloaded with the number of plugins we received, trying to process them all and get back on track.
So we have reinitiated all the “get values” calls and, could you please check it out and let us know if it works?
If you still have any issues, we have a few other ideas to try, so hopefully this would be fixed.
thanks


#10

Hi, @levon, thanks for coming back to me.

I refreshed the plugin page to see if it needed updating. It didn’t from my end.

I then checked the Get Numbers call and the same error as before occurred. See screenshot.

‘Value should be a number but right now it is an undefined value.’ - issue checker.

Note when I click More… it is empty - no options to select.

Let me know.

Thanks, Levon.


#11

Also @levon - can you let me know how I move a Thing Id to Sheets an/d what call to use to get it back?


#12

Richard, we have published a new version, can you please refresh the page, install the latest plugin version, refresh it again and give it a try?
please let us know whether it works…

didn’t quite get what you mean here, can you elaborate on this please?


#13

Will check. I want to pass the ID string of a Thing (the 16-24 char string - or however long they are) - probably as a text string? And then get it back to a record of the same type.


#14

as you can refer to a thing’s unique id and pass it as a string. But not sure what you mean by getting back a record of the same type from the sheet


#15

Updated the plug in and it’s broke the Get Dates that were working and the Get Number is the same. Doesn’t work. See screenshot.


#16

On the string. Understand I can pass it. But what about getting it back. I only see Get Dates, Get Numbers, Get Yes/No but no Get String or Get Text?

Let’s try and get Get Numbers working first if we can first

Thanks for working to sort this Levon.

R.


#17

you can use formatted values, unformatted values, range, column - all these use text field types.
but if necessary I can create a separate one for text

just pushed another version - please update the plugin on your side and give it another try after refreshing the browser


#18

@levon, thanks so much for this. Am now successfully bringing dates and numbers back from Sheets.

I’ll continue testing as I move forward. Thanks again.


#19

Great Richard, glad it works :slight_smile:


#20

@levon can you confirm if Get Column, Row and Range are working as expected. I’m not sure If I know how to get it to work at all. See screenshot. It doesn’t allow me to resolve the expression.

I’m guessing it’s the same issue as the previous calls but this time related to lists of values needing to be defined to match the target field type in Bubble?

Reason I may need this as at the moment I’m returning around 20 gets for each of 60 records.

At the moment It’s taking around 5 to 10 minutes to get what I need back into Bubble and hoped this would be a possible workaround to speed things up so I can continue finalising the app and testing.

My intention is to get it all bottomed out so that I might have you guys (and / or Jarrad as discussed with him prior to your partnership) create a set of custom functions that would speed up the whole process so it’s fairly instant for the user.

All the calculations are pretty much there in Google Sheets creating the results I expect. My issue is getting the data back into Bubble fast enough.

Hope you can help.

Thanks, Richard.