Good Morning,
I am using Airtable for an application that records users’ emails and some information that is presented in a table. What I would like to know is how to receive a specific row and column in the application.
Example:
In this case I would like to put in a text box “Information from 3” but since there are users registering all the time, the app doesn’t know what the “Row Number” is.
Thank you.
You can use get row block or get column block of the spreadsheet component
And to find out any specific user you can get all the data and compare it with any text or directly read the text via index
Thank you very much, I will try it.
I’ll tell you in a moment.
1 Like
But, in “Get Row” you need to write the “Row Number” to receive it.
So what you exactly want… Please give a detailed info so we can help you
What I want is to get, from the row “[email protected] ” the data from the Info column and put it in a text box. (In the example of the image)
Getting a specific content is not possible but you can use the read all data or whatever the name of the block is for reading all data and can store the data in variables whichever matches the specific data you want
Soham_Shah
(Soham Shah )
June 29, 2020, 6:53am
#10
Hi all,
I have a list which has many items and many of them are repeating. I wanted to get the index of all the items that match with “batch1” but when i use the index in list block i get the index of only one item so how can i sort of this problem?
You can refer to this topic
One last question, is there a way to do something similar to what I want to do in Kodular with other block?
Soham_Shah
(Soham Shah )
June 29, 2020, 7:00am
#12
Getting all data and filtering it using if condition block
Thank you very much for your information and attention!
1 Like
Soham_Shah
(Soham Shah )
June 29, 2020, 7:01am
#14
What have you tried until now… Show the blocks if you are doing something wrong so we may be able to correct you
I have not tried, I have already had to do two posts about Spreadsheet, because, I did not understand it very well. Thank you!
pepocero
(Pepocero)
June 29, 2020, 2:38pm
#16
You can try this:
Note: This is a response I gave in a post. I decided to put it in the guide section to help someone else who needs to filter data in Airtable.
As the title says, the idea is to be able to obtain data corresponding to a certain specific date in Airtable.
First of all you have to know that working with dates is a little more complicated than working with just text.
I have a table on airtale with dates from 2019 to now.
And for airtable to sort them by date, you need to first tell airtable that…
Change the date to the column value you need
system
(system)
Closed
July 29, 2020, 2:43pm
#17
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.