Join the Community

Home
Directory
Events

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

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

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

4 comments

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!
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! 😊
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!
Channeled
APP
·
·
Hi Remen O.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: