Need help with displaying data in one row of table/RG from different data types

wasiq.res · 2024-11-04T18:45:59.769Z

hi guys,
I have been building a SaaS for a quite while now i am stuck with a problem which solution i cant be able to figure out.
The functionality i want to implement is that i am taking data inputs from clients side and from admin side into to different data types named with “client orders” and “admin orders”. Now what i want is to display both client’s data and admin’s data in a master table in one row (for one complete order details) , now the problem is first client inputs his data then the mail is sent to admin side then admin inputs his data, now i want to make master table in which one order will show in one row of the table, but the problem i am facing is that the clients data is displaying in one row and the admin data is displaying in second row and the rest of the entities are empty. i want them in one row and also an order with specific id will be in one row with its correspondence admin data, for example client’s input order with id no. 1 will be shown in same row with admin’s input order id no. 1 .
please anyone help me out from this , i have tried everything but cant be able to resolve this issue.

pattokane · 2024-11-04T18:56:33.167Z

Hi @wasiq.res , how are you?

I think I understand what you are trying to do.

So you have orders and within those orders you want to show data from the admin and client, yes?

If that is correct, you can either add the dataTypes to the orders or make a new dataType that houses that information that can then be searched.

Example #1 -
DataType = orders
dateField - clientData = client dataType
dataField - adminData = admin dataType

This way you can pull the data from both within the order

Example #2 -
dateType = order (that has an attached client and admin or a way to identity client and admin)
dateType = ordersData (this would then have all the data from client and admin within it)
Then what you can do is search for an orderData that order, client and admin = parents order, client and admin

I recommend example #1 as it is much easier to setup.

I hope that all makes sense

wasiq.res · 2024-11-04T21:54:39.353Z

I have already tried that (example 1), let me explain what i want , I have made a two input forms “client order input form” and “admin status input form” on two different pages “client side” and “admin side”, so the procedure works like this:
first client fills the order in “client order input form”
then an email will be sent to admin side that a client has placed an order.
third the admin will process the order and fills the receipt in “admin status input form”.
now both forms data are saved in one data type called “orders”
now what i want is a super table that will show the order of client and its correspondence receipt data in one row.
the problem i am facing is that in bubble the client’s data is saved first and then secondly admins data so when i make the table in first row clients data is displaying then in second row the admins data is displaying which i want it in one same row and also more importantly the client’s order data should in line with its related admins data , like suppose admin input the second order’s data first then first order’s data then it will be in line with wrong order. like i said the clients order data should be in one line/row with its receipt data .
let me know if you got the clear picture of what i am trying to implement and i am very thankful that you are willing to help me out in this.

pattokane · 2024-11-04T22:08:51.532Z

Would you be able to send me a video explaining what it is you are trying to do?

wasiq.res · 2024-11-05T00:15:01.768Z

There you go man

pattokane · 2024-11-05T01:33:34.944Z

Oh, that is a lot more complicated than I was thinking LOL

Is it ok with you if I send this to one of my developers to have a look over?

wasiq.res · 2024-11-05T04:06:50.741Z

yeah sure no problem .

pattokane · 2024-11-05T20:26:35.257Z

Hi mate, how are you?

I have one of my developers that has looked over your video and is confident they can do it for you but it would take some manipulation of the DB?

wasiq.res · 2024-11-05T20:38:16.034Z

ok that sounds perfect. So what is the procedure?

pattokane · 2024-11-05T20:47:08.338Z

I have sent you a message explaining how it would work mate

wasiq.res · 2024-11-05T20:48:18.826Z

Ok! Let me see it

wasiq.res · 2024-11-06T21:53:36.736Z

Our company is not ready to pay. So, I am going for another solution using airtable. If you tell me how to do it through bubble then it will be great

system · 2025-01-13T18:46:33.146Z

This topic was automatically closed after 70 days. New replies are no longer allowed.