[solved] api filter from thunkable
hello, how can i filter the result from a get call ?

i don’t understand why i see all the response and not only the one with “numerodigara” field parameter i set.

i have this code. where is my mistake ? [[schermata 2021-03-28 alle 00.10.06]](https://aws1.discourse-cdn.com/business4/uploads/thunkable1/original/3x/8/2/8255ba2e8ea77e5504084b1fc93596c24a2c8aff.png "schermata 2021-03-28 alle 00.10.06")

thanks
in this case you need to use a feature in airtable api called filter by formula. the blocks you did will not work.
[image] mbraun:

****** please disregard, i figured it out. there was a sort column in the data that was not being updated for some of values*** .

yep. if you would want to filter those out from the actual report you would do that in power query.

nick

[[enterprise%20dna%20expert%20-%20small]](https://enterprisedna.co/enterprise-dna-experts/) use the query string to pass the venue id to the generic venue display page, make your <a> tags ref that page with "?id=xxx" at the end, from the venue page fetch that xxx value and query your db for that specific venue, and display that venue's fields as you like.


$myvar = $\_GET['id']; and thus  

Select * FROM table WHERE field='$myvar' hi chris, 
if you use relations api, you may set properties field in your query. in this field you should set the names of the properties which values must be retrieved from the server. the argument should be a string in the following format: "propertyname1, propertyname2, , , propertynamen" , wher… In the end, I found this query, which groups the way it should:  
  

```
SELECT 
 FROM_UNIXTIME( TRUNCATE( UNIX_TIMESTAMP( tstamp )/900, 0 ) * 900 ) as h,
 AVG( amount ) as v
FROM 
transactions
GROUP BY 
h
ORDER BY 
 h desc
LIMIT
 24
``` ok. i have solved it. the problem was a misunderstanding of what freecodecamp wanted me to do. first they stated:

you can make a get request to /api/exercise/log with a parameter of userid=\_id to retrieve “a full exercise of " any user”

so i thought they meant all the exercises of users in the … hi [@dr\_rainer\_demski](/u/dr_rainer_demski), welcome to the asana community forum :wave:t2:

in this case, i would suggest reaching out to our support team with the unique error code received as mentioned in the pop-up :slight\_smile:

you can reach out to the support team by clicking the support form prompt in the pop-up … thanks for getting back to me [@michel1](/u/michel1)! in this case, i recommend you to contact our support team: [how to contact our support team ✉](https://forum.asana.com/t/how-to-contact-our-support-team/87774). unfortunately i don’t have the tools in the forum to check what’s causing the error in your screenshot but our support team should be able to assist here.

when you c… done. [links to api, release notes, derived formulas, etc](https://community.weatherflow.com/t/links-to-api-release-notes-derived-formulas-etc/2450) .

thanks for the request / suggestion [@vinceskahan](/u/vinceskahan) ! [@kranji\_node\_store](/u/kranji_node_store)
[[scannable3]](https://aws1.discourse-cdn.com/business5/uploads/appsheet/original/3x/0/c/0c80b79dc2e966f5f39445343db2293bc4053a07.png "scannable3")
[[scannable2]](https://aws1.discourse-cdn.com/business5/uploads/appsheet/original/3x/d/d/dda4d711966f5851f213fa67ca11b4116745d6b5.png "scannable2")
[[scannable1]](https://aws1.discourse-cdn.com/business5/uploads/appsheet/original/3x/2/0/2026bb2ce6db7cfecff5276a0c82da1448a1a622.png "scannable1") > 
> i want to create ap application which generates popup alerts at the day of event ocurs as well as a day before the event will occur in a specific time interval as well.. events are stored in database and they are all date fields .. so i want to link those fields to create popups .. help me .
> 
> 
> 


In order to help you, you must first provide us with what you have achieved. We do not write code for you, simply correct and enlighten on mistakes.