Hello everyone, I’m new to WeWeb and am currently in the process of implementing a project. I use the Airtable database and am currently in the process of creating a data grid in WeWeb. A collection with the name “users” is retrieved there. The IDs of contact persons are also preserved in the “users” table. The contact persons are contained in another collection “contacts”. I managed to display the data from the “users” collection, but not the associated “names of contacts”, which should also be displayed in the data grid. In the frontend I added the “Contact Person” field and now need to provide this with a formula. Here I am having problems applying the correct formula, so I now check whether a “contact person ID” is stored in the “users” data set, if so, match the ID with the “contacts” collection and give me the name of the contact person back. There can also be several contact persons per data record (multi). What could the formula for this look like? Not every user has a contact person in the data set. only one in the picture
You probably are looking for the lookup function
I tried using the lookup function. But I don’t have contacts everywhere and then I tell myself that there are “undefined” data sets. Some of the lists actually have two contacts, but only one is shown here. Two problems that still need to be solved. 1. Where there is no contact person, it should not say “undefined”. 2. The second contact person is actually missing from the last data record in the list.
I think you should do this kind of “more complex” operations on the backend. Are you using Xano or Supabase? Or something else?
Edit: I see, Airtable. Isn’t there a way to join data while querying there?
I created a link in Airtable. Now it’s about getting the name or several names from the “contacts” table to be displayed in the WeWeb Data Grid column “Contact person” in the image. and some simply have no contact person.
Does somebody has any idea? I’ve gotten it to the point where the data is displayed. The only thing I’m missing now is that the name should also be displayed in the “Contact person” column instead of “object”. See image. Can someone help?
Any solution ? I have the same issue.
You can simply type [0].name after the filter, this selects 0th (first) item and returns it’s name