Hello everyone,
So I have an application that uses two languages Arabic and English and I have a list view and a search field and in my Supabase database I have FirstName, LastName columns in a table for both languages so in total they are 4 columns, I want the user to be able to type whatever in the search field then I want both FirstName and LastName fields to be searched and show relevent results in the listview based on the language used at that moment so if the application is now set to Arabic retrieve the First and Last Name Arabic fields only and also I need to get the id field related to each search result displayed, any suggestions on how to accomplish this?