- My goal: to see the child records as a table under the mother form.
- Issue: I made the tables in retool as an example with a few records and a few fields. When viewing the datarecords you can see the linked data. but not in a form view or APP. So the foreignkeys seems okay
- Steps I've taken to troubleshoot: Seeing several youtube films, asked copilot purchased a Retool online course but no success.
The future plan is to have our data in the Google-Cloud-Postgresql or Supabase with Retool as tool to update the data. better ideas?
1 Like
Hey there @De_Trekbarefoot_Trekbarefoot, and welcome to the forum!
I'm sure you can get all the help you need from people in this forum.
Would you be able to share more context about your data and how exactly you want it to show?? Screenshots always help, even id they have a painted square showing where you would like data to appear.
This not my example of course.
I do not need three buttons at the top. I need a search bar to search in one field to find the right grand mother record.
Hi Miguel,
Thanks for reaching out. In MS-Access it was called a subform, and very common used. I do not know if this is also very common used in Retool.
Suzanne
It is used to complete the empty fields in the grant mother table. The data of the daughter and grand daughter table are imported. They have also their own form, when occasionally updating of the records of the daughter and or grand daughter table are necessary. I can read SQL, but I am not used to Java.
Thank you for the screenshot and additional context, I think I see what you're trying to do, so if I understood correctly, you would like:
1- A search bar where user will type a name or an email.
2- This search bar will trigger your SQL queries and bring both parent (e.g. customer info) and child information (e.g. customer orders) for a given record
3- You want to populate a form with the parent record, and allow user to edit it
4- You also want to show child records and allow them to be edited (potentially with a pop-up or a side drawer).
Is the above correct?
That is correct.
I think it is not important for my question, but I have a not normal situation in the mother table. The records in the mother table can only be made after the daughter table already is imported (regardless if the grand daughter is also already imported).
The data will be imported in the daughter table (first), the data of the grand daughter will be also imported (second step).
All the tables have a primary key with autonumber.
Occasionally a record in the daughter table or the grand daughter has to changed.
I tried to make some test-tables with a few records directly in Retool . Besides the primary key with autonumber, the tables have a one field which is also unique.
The unique field in the grandmother table is a combination of the unique field in the daughter table and another also unique field in another table (I didn't mention that table before) that has a 1 to many relationship with the daughter table.
So, I made a field in the table of the daughter that makes the combination field. The combination field is not unique for the daughter. I made an update query that let the grand mother takes over that field.
Very seldom, the also unique field in the daughter changes. I made a query that changes the combination field and a query that updates the field in the grand mother as well.
Maybe it is possible to give you acces to my retool test.
Sorry, that is not correct. The unique field in the grandmother table is a combination of a not unique field in the daughter table and another not unique field in the daugther (which is actually looked up in another table where it is unique. That table, which I didn't mention before has a 1 to many relationship with the daughter table.
You are correct.
I gave extra back ground information which you asked and made a mistake in it which I corrected. But it has nothing to do with my question.
I would expect my question is common and was given as a standard by Retool.
It is made thousands of times in MS-Access (form with a subform).
Hi @De_Trekbarefoot_Trekbarefoot, we had talked in another thread but I wanted to check in here. How is your app coming along? If you have specific questions about app building or queries fell free to let us know.
Hi Mike,
- You mentioned a new version was released in August which would improve things that I struggled with. Did I miss it how one can get the new version?
- I really tried to make it work and put a lot of hours in it. But I think, somewhere I miss a vital step. Can I give you access? The data, I put in the Postgress database is just example data. It is not a problem if records are lost or changed.
We can do things with tables which we couldn't do with a form.
Hi @De_Trekbarefoot_Trekbarefoot, I was alluding to an exciting "Copilot" feature that is currently in Beta testing, but is not currently available to everyone yet. Ideally with this feature you wouldn't need any templates since you could just ask the copilot to do a mock up of what you're describing for you, and modify it to your needs from there.
As to your current app, you could export to JSON and DM it to me if you'd like, or you could share what specific issues you're having here in this thread.