I've a big google sheet with a lot of fiels and i'd like to can found a solution that can give me a sheet block with get function on that to have ALL my columns and not to have to add manually every one. After i will assign the column to my variable and i know that this have to be a manual job but to have an automation for this will decreas at 50% the work to do in the cases on that we need to show the values form sheet to or bot and i think that a lot of times we need to show all values got from sheet. Thank you
Wait- if it is not manual, how will the bot know where to put the information?
I'm confused.
But some ways to get all the information from a sheet would just be set column variables and append to them in a loop for the sheet row length.
And also this example from @CptPlastic is amazing. I've learned nocoDB is SO MUCH FASTER than sheets and his example is awesome for something similar to what you want- getting all of the table values and displaying them (in his case in buttons).
Maybe there are some things from his example that could help you and maybe you could just copy over your sheet to nocoDB and either keep it mirrored or just use nocoDB...
thankyou very much i will go to see and try to study the example. Sorry but i've not received any notification about your reply and i've discovered only now opening newly Discord
