Hi everyone,
I would like to know how can I retrieve the specific data from Google Sheets.
Lets say I want to retrieve the leave from and to dates for user ‘x’ in the screenshot. Can anyone help me with this. (This Sheet is connected to a google form so It will update regulary)
Thanks
Or pls tell how I can implement this in airtable
Hi so this block has the column block I dont know which column the value will be since its a google form it could be any integer
Its standard 1 unless you change it manualy.
Hi,
So I don’t know the column number in which the value will be as it’s a google form and it also can have more than 1 row for a particular user as shown in image.
My idea is to get filtered data for user “x”
I don’t know if there’s an api for it if it is pls share the same
Hi, So I found an api for the same it shows the filtered value in json
so I want to retrieve these values from json
[
{
“Name:”: “X”,
“Leave Start Date”: “6/23/2021 11:42:31”,
“Leave End Date:”: “6/25/2021”
},
{
“Name:”: “X”,
“Leave Start Date”: “6/23/2021 11:42:31”,
“Leave End Date:”: “6/25/2021”
},
{
“Name:”: “X”,
“Leave Start Date”: “6/23/2021 11:42:31”,
“Leave End Date:”: “6/27/2021”
}
]
as a list here is a sample on how it should look
The blocks I am using are these( I am first trying to retrieve the usernames ‘X’ )
but it just gives a blank screen since it didn’t get any values from the API
Sorry i can’t help there.
Haven’t yet learned to work with API’s
Hey @muneer could you share the project link for the same.I wasn’t able to find the list of values blocks and get value blocks.
Thanks.
I deleted it already sorry.
You will find these blocks in the Data Sources drawer in the blocks screen.
If Data Sources is not showing in the block screen then you need to add a data source which you can do here (for Snap to Place UI)
Or here (for DnD UI)
Hi,
You haven’t used the json blocks or the api get blocks so how would we get the value from api. If you want I can share the project link with you in Personal Message
This has nothing to do with API. Use only Data Source connection.
My data source keeps getting updates being a form spreadsheet so I don’t think that data source connection would update each time a new response comes.
The same is true for the API. The Data Source connection or API Get will retrieve the information upon request.
