Getting a third value from a row if first two values match a row in API database
I am trying to create a formula logic for a form and an output , which checks if two values exist in the same row in columns A and B . If they exist - it returns the value in column C . E .g . can be used for checking status of an order - you enter your order number and post code , and you get order Status as output . I created two attributes - order _number and postcode , in which to store the user input . However , I have no idea what formulas to use to check for exact matches for the two variables in any of the rows within the API array . Any help is appreciated ! ✅1It sounds like you want to compare a value from your API call with an attribute in your component ? I 've shown an example here where I 'm using the weather API , and if the index matches my "hour " attribute on my component , then I show "Match " rather than the temperature . So you would use the Equals formula - potentially combined with the If formula to apply the correct value . Does that make sense ? Or did I not understand your issue /question correctly ? 😅 ❤️1Right , it is similar ! Let me provide some more details and examples . First of all , it appears that the structure of the data from the API might be making things difficult . In your weather API , you dynamically get the data for the relevant city . With my google sheet api , I get all the entries in json format and basically when I want to say "get Status " , I have to point to a Status in a specific row , e .g . "1 " - which makes it static . alternatively , if you enter Order ID 1001 but postcode 2005 , it should return "No result " , since those two values match no row Ah I see . In that case , I think you 're looking for the Find formula that allows you to search through an array of elements to find a match . In your case , you would then match your values against the order number + postcode columns to see if there 's a match . And if you find a match , you would then display the status . I 'm not quite sure about your data structure , but in this screenshot is an example of how you might achieve it Thanks for the effort , I really appreciate it ! This is the API I am using Your API seems to return an array of objects . If you paste your url into a toddle API , it should fetch the data automatically and let you work with each column separately in formulas . I 'm not quite sure I understand your specific issue . Perhaps you could share a video and /or invite me to your project so I can help you out ? erik @toddle .dev
.jpeg/public)