**I just had a chance to look at your 5-minute CRUD video, and go through the example. My question is how do I create a CRUD app as mentioned above without using the Repeated Panel component?
Can I create write-back data binding with labels and textboxes (as the results of a data query)? I know how simple it is to create one with the repeating panel component, but I was wondering if its possible and if so a simple example on how to do it.**
anvil.tables.TableError: More than one row matched this query
Learn more about Data tables
<running on the server>
called from /libanvil/anvil/_server.py, line 42
called from ServerModule1, line 27
called from admin_haga_system, line 149
The problem is that I want it to display the information they place.
Example:
Company Name: XYZ
Admin: Tom
Email: Tom@outlook.com
etc…
When they click save, the row should save and the information to be displayed. When they change something and press save, it should save it and when they log off and on it should be displayed in the textbox again.
Have you been through the News Aggregator tutorial, specifically the step where they talk about editing an existing article? It goes through the techniques you need: Anvil | Update existing articles
I think if this is what you want then this design is more complicated than it needs to be. You should just put a Simple Object column in the Users table containing a dict with this labeled information:
…and load the information from anvil.users.get_user() to populate it when they log in.
Then if the user wants to make a change, make a server function call passing the changes to just the simple object column (dict) and have the server_module update the column from its own call to .get_user() to make sure the logged in person can only change that one column and only their own data.
