Welcome to the community, @The_infinity_Verse! :grinning_face_with_big_eyes: This is definitely doable, but we’ll need to know more about your setup before we can effectively help. Do you have some example code that you’ve already tried, but it’s not working? If so, please share the script here, making sure to style it using the </> button on the comment editor toolbar.
If you don’t have any sample code that we can help with, I would encourage you to read up on the fetch command, and also peruse Airtable’s API and the use of the filterByFormula property.