Clay Icon

Issues with Array Position Formula from Clay Team: Video Guides Included

Β·
Β·

I'm having issues using the Array Position formula provided by the Clay team - more details in this Loom: https://www.loom.com/share/6c8b7bf9edd24efabfcdeea8b0d93898 here's the video guide I received for numbering rows: https://www.loom.com/share/42c7f8be9bbd4ca69165e01d6377dd01?sid=f0234a49-0e17-4ae6-ac96-799aa40d53eb Link to Clay table: https://app.clay.com/workspaces/354814/workbooks/wb_yminVz8MSaiB/tables/t_Ytki9s879ZBb/views/gv_vKGRmkqyXGgi

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    πŸ‘‹ Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Bo (.
    Bo (.
    Β·
    Β·

    Hey Remen, thanks for reaching out! 😊 I noticed there were some errors in the formula. Here’s what I did to fix it: 1. I took a screenshot of the formula in the Loom video. 2. Sent it to ChatGPT to return the formula as text. 3. Copied the formula and replaced {{Unique ID}} with the actual value in the table using the forward slash (/). 4. Finally, I force-run the entire rows, and it works now! For future reference, feel free to save this formula:{{Unique ID}} ? ({{Lookup Multiple Rows in Other Table}}?.records?.findIndex(record => record['Unique ID']?.toLowerCase() === {{Unique ID}}?.toLowerCase()) + 1 || 2) : 2 Let me know if you need anything else! 😊

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Hi Remen O.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: