I want to get the cell number after getting data from Excel sheet…
Here are some images to understand better…
This is how the app look and everything is dynamic…
Here you can see I am getting all data but showing only few which contains specific text…
This is the Excel sheet and I want to get the cell number and not the dynamic cardview number…
2 Likes
I am using spreadsheet may this is also available in excel
No @Faraz_Firoz1 , he is using Google sheet but the above block will work with spreadsheet (airtable only)
You cannot pick exactly that value. You need to compare with known vlaue of that row then only tou can take it.
Select L where A watched 'textbox text'
Let me share you a link , first go through slowly then really this …
Easily can be achievable by using gviz query
Your url must be, (use text join block, use three fireld. 1st filed URL, 2Nd field textbox text block and 3rs block ’ (hypen alone)
https://docs.google.com/spreadsheets/d/<Ur gsheet I'd>/gviz/tq?tqx=out:csv&gid=<your sheet gid number>&tq=Select A,B where A contains 'Appl
You have to replace the textbox text block in place for Appl.
For more info
This is not helpful for me…I am sorry
This will give me the cardview number not the Google sheet cell number
sugarlesscreator:
Return index/number
Have you try
Its return 13 if you click delete job button or any number by click of dynamic button
I tried it should give 1&15 but instead it’s showing 1&2…the above given picture which shows 13 is an example…
@sugarlesscreator in the Excel sheet there are 15 data out of which I am only showing 2 data…as you ca see my blocks above given picture I am removing items from the list and extracting the data with a specific name…so to delete those data from Google sheet I need the exact number which I don’t understand how I can get that’s what I need help with
This will give me same as number 2
I have to get the number before removing items so that I get the correct number, but I don’t understand how I can do that
Can anyone please help me how can I solve this
1 Like
_FTTX
(Ali Abo Wardi 0 iraq)
May 18, 2021, 8:48pm
#17
Make a new column and insert the cell number in it and call it in the application and do whatever you like
.
.
.
.
.
I don’t want to do that, I want to do the way I have written above and also shown using the block…can any one please help me in that manner…can any #procoder please help me
I have created the list but don’t understand why I can’t get the index from the list always getting error…can anyone please help me?
First show us your when web got text block.
I hope you may not add list from the CSV table text
just before the response content