Logic for Finding and Retrieving Associated Records Between Two Data Sources

  • andyputilin-1364032330708287629

    Andy Putilin

    20 hours ago

    Hello, need a little help with what I believe is toddle logic.

    I’m building a CRM page and pulling in data from two APIs — one for deals and one for vehicles (stored in Xano). Each deal can be linked to a vehicle using an ID field.

    What I’m trying to do is this:

    When someone’s viewing a vehicle card in the CRM, I want to automatically check if that vehicle appears in any of the deals. If it does, I want to pull in the info from the matching deal and display it alongside the vehicle. Kind of like showing deal context directly within the vehicle profile.

    Right now in Toddle, I’m looping through the deals and comparing the vehicle ID to the current vehicle being viewed. I’ve been trying to make this work with a formula, but it’s not returning anything. Clearly I’m missing something 😅

    Dropped a screenshot of what I’ve got so far. Just wondering what the best way is to structure this logic. Should I be filtering differently, or is there a better way to query it from Xano?
    1364032331555278889-image.png
    1364032332067241995-image.png
    1364032332499124224-image.png
  • kingdragxn-1364054864451338430

    Jay | DRAGXN

    18 hours ago

    Hello! 🙂

    Could you share your the URL of your editor so I can take a look? You can send it in a DM if you don’t want it public.
  • lucasg-1364100788087160924

    Lucas G

    15 hours ago

    That equals node is checking a string against an array. You’ll need to change the formula to get a proper Boolean response
  • andyputilin-1364129977359925268

    Andy Putilin

    13 hours ago

    How do I convert the array into a string but then do it in a way where it checks it for each vehicle though?
  • filip_dajkovic-1364149625816219709

    Filip Dajkovic

    12 hours ago

    You need to change it to look like this
    1364149625644126290-CleanShot_2025-04-22_at_10.02.592x.png
  • lucasg-1364212365591056404

    Lucas G

    8 hours ago

    As Jay said, are you able to share the project or what data looks like so we can help
  • kingdragxn-1364260487654805535

    Jay | DRAGXN

    5 hours ago

    Don't worry, we were up for 8 hours and got everything working... 🤣
    🤯1
    🤯1
    🤯1
    🤯1
    🤯1
  • lucasg-1364260700532244501

    Lucas G

    5 hours ago

    8hrs??? @Andreas Møller maybe this guy could be our next viking...
    👀1
    👀1
    👀1
    👀1
    👀1