I’ve created a table to showcase all the invoices that I am storing in a postgres table named project_invoices. I’m attempting to create an omni-search bar to help users easily find the invoice they’re looking for, however I’ve run into two issues:
// Access the project_id from Item.data const projectId = context.item.data?.['project_id']; // Access the project data from Projects_postgres.data const projectData = collections['27b5e82c-27a4-41db-a259-5ce904666332']?.['data']; // Find the project with the matching id const project = projectData.find(project => project.id === projectId); // Return the project name if a matching project is found, otherwise return an empty string const projectName = project ? project.name : ''; return projectName;
However, when I go to filter the collection list, I’m unable to filter based on project_name, and instead need to use project_id which isn’t as useful for a user-facing filter. Any ideas?
- Similarly, I store the invoice amount in cents in the database, but I display it in dollars using this no-code formula:
Is there any magic I can do to get the omni-search bar to filter based on the dollar amount, or will I need some sort of low/high filtering to get that done?