Hello everyone.
My problem is this. I have a table in airtable called Clients and another table called Prospects. I have a list block showing all Prospects and a details page that shows Clients who are also possible prospects and the details for this clients would be gotten from the Client table.
On the Clients table, i have column called {link to prospects} which is linked record to the Prospects table.
The problem i am having now, is that the Clients details block isn’t showing any details with my conditional filter. The condition i have is: if {linked to prospects} includes exactly the Current record’s Name (which in this case, is the Prospect’s name), then it should show all clients who are linked to that Prospect. But right now, this isn’t working.
I tried using chatgpt to give me an insight, and it tells me it’s because my prospect Name is a formula and Softr isn’t recognizing it.
Please has anyone encountered this sort of problem before and how did you solve it?
Thank you…