You are too Good @JEWEL …
Getting Error Cannot read properties of Null(reading ‘getDataRange’)
I bought the premium version
@JEWEL
1 Like
First of all you should use Get All rows and then when Got all rows then use any feature …
I am using @JEWEL 's Extension since 1 year and never got any error
but i got data of almost 3k rows Wont it make my app slow ?
Also how do i convert from JSON TO LIST of so long data
Also how do i only get a single row like the one shown in his youtube video
Hello @Sidhesh_Tavare, I’ll take 2-3 days to help you. At this time I’m in hospital for my wife. Hope you’ll not mind if I take 2-3 days.
For now, please follow my tutorial playlist from the first video.
1 Like
Thanks for your wish.
In these days you may take help from @Mr_YouTuber_Official, he is very helpful. I hope he will help you. He is very experienced user of mine extension.
2 Likes
No it Will Not slow
Get all rows just work to get spreadsheet load into you phone then it will take 0.000001 second for all features to get any data.
Don’t forgot to check Offline mode
1 Like
For More info you can Inbox me
1 Like
Today I have purchased this wonderful extention . jewel is a great guy , very helpful and polite
2 Likes
@ahossan649 whoever understand it will share lot of love and thanks to @JEWEL …
He is such a great great Developer …
Thanks
I will definitelly suggest that you do not buy this extension. Once you purchase it the developer will not give you any updates, He promised 5 years of updates when I purchased it. Few months later he did not even reply my messages, I’ve been waiting 6 months already…
Tell me your WhatsApp/Telegram username and text me again there with your email address.
1 Like
We do not believe @Elizabeth_Garcia .
Because @JEWEL always Give Reply and Send update to our registered email whenever a update is available …
@JEWEL is trustable Person …
If you have any complaint about extension or want to know about any error you could contact me so i will guide you …
Because i learn it from Jewel and his extension is too Good
1 Like
Could you give me a tip on how I can use MultiSqlQuery to make a filter, since I need to use “OR” and “AND” in the ‘condition’ but only OR or AND is allowed?
because I need to filter if it contains 2 or more parameters from one column, “AND” 2 or more parameters from other columns,
because if you only use ‘OR’ in the condition, the filter will return all the values, if you use ‘AND’ the return will be EMPTY.
GENRE, AGE, NAME, CLASS APPROV, …
Male, 35 to 44, Mario, Regular, Yes, …
Female, 25 to 34, Taiz, Good, No, …
Male, 25 to 34, Sebastião, Good, Yes, …
Female, 25 to 34, Marcia, Great, No, …
Female, 35 to 44, Maria, Good, No, …
Male, 45 to 59, João, Good, No, …
Male, 25 to 34, Paulo, Great, No, …
Male, 16 to 24, José, Good, Yes, …
ex:
MultiSqlQuery
columnsToSelect = GENRE, AGE, NAME, CLASS, APPROV
ColumnsToSearch = GENRE, AGE, AGE, CLASS, CLASS
keywords = Male, 35 to 44, 25 to 34, Great, Good
rules = Equals, Equals, Equals, Equals, Equals
condition = ???
limit = 0
isIgnoreCase = True
MultiSqlQuery
columnsToSelect = GENRE, AGE, NAME, CLASS, APPROV
ColumnsToSearch = GENRE, AGE, AGE, CLASS, CLASS
Example: keywords = Male ‘AND’ 35 to 44 ‘OR’ 25 to 34 ‘AND’ Great ‘OR’ Good
rules = Equals, Equals, Equals, Equals, Equals
condition = ???
limit = 0
isIgnoreCase = True
EXPECTED OUTCOME
Male, 25 to 34, Sebastião, Good, Yes, …
Male, 25 to 34, Paulo, Great, No, …
I hope you understood my question, and thank you for your help!
It is very simple , AND means all condition Matched and OR Means any Of Condition Match …
Just test it will work @Amarildo_Correa_de_Souza
but the condition only accepts “one” parameter, or is it ‘AND’ or ‘OR’ how can I implement it?
As you can see in the image, I don’t get the result that should actually be for a specific filter!
Are you using latest version of this extension?
1 Like