Issue mixing databases

Need help Database
1

Hi all,

I have 3x database that needs to be communicating with each other.

  • Users database (Person who book a professional)
  • Experts database (Professional who receives booking)
  • Bookings database (Order number etc.

On the Expert profile, I want to show their next booking. All works well when I connect fields to Booking database.
However, I am also trying to give information to the User who made the Booking.

I am then trying the following:

  • Image elements search for picture of a user (Search for Users)
  • The user ID is determined by the booking (Search for Booking)
  • The Booking is depends on The Expert ID is currently logged and the status of the booking (Current user’s Expert ID)

I then created the following:

image
image698×420 19.1 KB

and the “Search for Bookings” is as follow:

image
image696×413 19.8 KB

However, nothing shows! I tried different way such as populating an input with the User ID field (which works) but then the image does not appear.

I also tried to do the same with a text database input, but again nothing shows.

Can anyone point me in the right direction? I am unsure what else to try.

Thank you

2

You have 1 database with multiple datatypes

Do a search for Bookings where created by = current user. Is this what you’re doing?

What do you mean exactly? The RG has no results? Or searches that you’re doing within the cells aren’t working?

3

Hi Alex,
Thanks for this.

I believe the issue is related to the search flow that I am currently using.

The flow is currently:

  • Get the image of a user
    (Search for Users:item #1’s Picture)

  • The right user is the one that has a booking ID
    (Unique ID = Search for Bookingss:item #1’s Booking User ID)

  • The right booking ID is a booking that has the Current user ID
    (Expert booked ID = Current User’s Expert ID)

Therefore Expert A will have a booking B
booking B will then have a user C
user C will have a picture
and I would like to show that picture directly from the database.

Sorry if it’s not super clear - first time that I have an issue that I am posting on a forum like this.

4

Please post screenshots of these 3 datatypes and also explain in plain english what you’re trying to do. So instead of “Get the image of a user” it would be helpful to have context…“Show the logged in expert the image of the user who booked this meeting with them”

5

This is what I want to do:

When an expert is logged in, I wanted them to see the bookings they have.
On each booking, I want to show the picture of the user

Screenshots below.

Booking datatype:

image
image315×606 21.8 KB

User dataype:

image
image354×627 14.7 KB

Expert_id in the User section only gets populated if the user is an Expert

Therefore what I am trying to do on the expert profile, is to look for their Expert ID → look for their bookings → find the user who booked → show the picture

I hope this makes more sense?
Thanks!

6

Add a user field to keep track of the expert that the booking is associated with

Search bookings where expert = current user

image datasource = this booking’s creator’s picture