I’m new to bubble and learning it for fun. I have been working on a project and need assistance. I’m fetching data from an api and have a data static database loaded via CSV file. How do I look and compare the data from static and api.
Example: I’m fetching role and a company from an API and I have some roles and user names already saved in my static database. How do I create a search such a way that my role from api searches role in static database and when it finds a match it displays user names.
you simply use get data from api when looking for company name. Here’s a quick example. but be careful for case matching (make all lowercase if you need to) when matching roles and make sure the current user has access to other user names and roles (privacy rules).
so does the example; it looks for all usernames in your static db who have a job title existing in the api response and lists them. I’m not showing companies anywhere. here’s the setup.
Apologies. I believe I’m not able to explain it correctly. Database one is filled by Person looking for a job so we have name and Role. Second database that has Company looking for people that has company name and role. I need to use the common role from both database to compare and display my data to the admin.
no worries, I get it now. Still doable. there is no need for the top two RGs but I just added them to show you how each datasource works. Same editor link.
it’s not a formula, this is just a search that filters the API data by role to get the company. The answer to your original question is yes, what you are trying to do is feasible.
Thank you so much Hanan for all your help. I was unable to connect my database. I followed the same steps and searches and still doesn’t work. Maybe I’m missing something very basic.
