You can enter data into the spreadsheet by row, but to obtain the values they will always be in columns. You store each column in a list, I recommend using the Web component.
Use GetRow function to get row values easily and faster.
(Thanks)
I am still waiting for an update sr, I do not need the most updated but at least one that supports SQL queries
Another thing I didn’t understand, when I use CreateRows and some value contains a “,” comma as shown in the example image, it is separating into a new column, is there any way to fix it?
Since you are using “,” it is expected to happen that way. Remember that lists are comma separated items
I actually don’t agree, because I’m already inserting it into a list! individual items and not in a formatted string, but how can I insert a comma then? and don’t separate the columns…
because this list looks like this: [“Column A”, “Column , B”, “Column C”]
os list length: 3
Then you will need to read the documentation. You see the Make List block but in reality what you are doing is “Column A, Column, B, Column C”
it is like this [“Column A”, “Column , B”, “Column C”]
os list length: 3
This really happens, you can save the data Column. B and when you download this column you convert the (.) to (,)
The same thing with monetary values.
in fact it doesn’t make sense, I think it could be a bug in the extension, just like any other character it is possible to insert it, because if I wanted the B to go to another column, I would put it in a new item in the list, right! Otherwise, you will have to replace the “,” character when sending it and reformat it in the Google table, an unnecessary service!
My God! Everything is like this, I can’t use “,” comma in any cell in the Googlesheet, which is creating new items in the lists, I’ve never seen this, because in the other extensions I use it doesn’t happen like this! now everything is messed up here, because I was aware that each value in the cell would have to be an item in the list, regardless of the “,” comma in its content, as it is a database and I may need to store text and this may contain “,” comma, what now?
Hello, queries in the SqlQuery block are limited to displaying only 1000 records, if I use a query that has more than 1000 records it only shows the first record, is there any way to increase this limit value or any way to display all the records in the query using the SqlQuery block?, thanks!
I have been a loong time trying to get an updated version that Supports SQL, I bought the extension quite some time ago but never received the updates as suggested by the Developer. I have been contacting him almost every day via Telegram and he only ignores my messages…
The extension is really difficult to use, lots of bugs! As I already reported in the comments above and directly to the developer, the SqlQuery method is limited to displaying only 1000 records, which in turn I have already researched and even sent the “solution” privately for testing and deployment to the developer, another problem of ", " comma, I can’t have commas in the spreadsheet cells, which becomes a mess when importing data or sending it, also reported! For some time now, I’ve been disappointed in having to switch to another alternative, as I’m a subscriber to the Speedster Edition plan, because what I need is exactly what doesn’t work!
i think you should get alternative solution of that…
Hello @Amarildo_Correa_de_Souza, V14 is ready to go. Please text me on WhatsApp to have this update.
The Got All Rows, get response Content method is returning the data in a mess full of " and \ , with blank values, in addition to the comma problem in the cells being transformed into chaos.
can you show your issue here?
Which edition is selected?