Hi Mike,
I just started with Retool and miss some basic examples for standard situations that one could copy and explore (like I do with Figma).
The basics of every database is normalisation, define primary and foreign keys, and put data in different tables. To view or edit that data, a main form within that a table/subform with expandable rows is one the most used forms in MS-Access. It is so often used, that Microsoft made a wizard that guides users through the proces.
A searchbar shows the record in the main form and the records shown in the subform belongs to the record in the form. A button to edit the record in the main form, a button to delete the record in the main form and a button to open the child record in a normal form of its own. In that form also a searchbar en buttons to edit and delete the child record.
An example with a few fields and 4 records in the main table, 10 in the child table and 16 in the grand child table is enought to cover endless situations like this.
Example: A company with departments and employees or any common example will be sufficient for users how to use it in their own situation.
For obvious reasons, MS-Access is no longer save or suitable in many cases.
Can we expect in the coming new version of Retool this sort of examples like a template that you can use?
Hi @De_Trekbarefoot_Trekbarefoot, I went ahead and split this into a new topic. I think you make a great case for us having a template for a common use case with MS-Access. While this specifically isn't something that's on our radar, stay tuned for future versions as we have a lot of exciting features in the works.
Regardless, I submitted a feature request for you. If it is something commonly requested, then it has a higher chance of being implemented.
Aside from this, I encourage you to continue building your app out in Retool! Templates are very useful of course but from what you've described in this post and in your other thread, I'm confident you can build what you're looking for.
Hi Mike,
The reason I asked it, is because I can't as my knowledge Java is not good enough and put my question in the forum. So far, no one can help me, so I put my question today in Appsmith forum as well.
In the past I made a lot of things in MS-Access and most of the projects had this type of form. I think quick learning is best done with a few templates so you learn by investigating a bunch of examples. So newcomers can make a quick start.
To be able to know whether this template or any other template is popular, one should be able to vote about which templates / examples are most wanted or suitable.
That is totally fair. In regards to getting help here, sometimes very granular/specific questions can get answered very quickly, whereas a broader question about higher level app building may take longer to get a response. While you wait for a response, my recommendation would be to try out Retool University. It's free and it's a great way to focus on what you need to know for building in Retool without taking some separate JavaScript online course.
I agree that additional templates would be helpful. However, they can be difficult to maintain as the product goes through updates. Another idea that's been talked about to address this is an app marketplace, where users could create, submit, and maintain common apps for everyone to use and learn from, but this has yet to be implemented.
Like David said in the other post, our next launch by the end of this month will be a substantial step forward in regards to app building, and I think it will be helpful to you.
[quote="De_Trekbarefoot_Trekbarefoot, post:5, topic:60767, full:true"]
I started with the university. And I also continued with my project.
What is working is that when you select a row in the table/subform, the other table which is a daughter of the daughter, shows the rows belonging to the row of its mother.
A problem is that when searching on a field in the form (grand mother, the table / subform lags behind. So I see the rows of the previous or even sub-previous search.
Can I share it to the community and how does that works?
Maybe you could use it as a standard example?
As it is an neutral example, I would love to share it.
Glad to hear you are going through the university!
From what I understand, it should be possible to have the subtable/subform update as you enter info in the search field. If the subform uses the value of the search field as part of the query that populates it, it should automatically update as that value changes.
Can I share it to the community and how does that works?
You are free to share screenshots or even upload your app export if you'd like!