old pythonTo resolve the issue with "Table1.newRow is undefined," please follow these steps to ensure that the Table widget is correctly configured to allow adding new rows and that the newRow property is properly referenced:
- Enable Editable and Add New Row Properties:
- Ensure that the Editable property is enabled for all the required columns in the Table widget.
- Enable the Allow adding a row property in the Table widget's property pane. This will display a button labeled "Add new row" at the top of the Table widget.
- Verify the SQL Query:
- Ensure that your SQL query correctly references the newRow properties. Here is your SQL query with the correct mustache syntax:
INSERT INTO public."departure_board" (
"route",
"created_at",
"date",
"departure_time",
"flight_number",
"id_departure_status_option",
"id_departure_passenger_action"
) VALUES (
{?{ Table1.newRow.route }?} ,
{?{ Table1.newRow.created_at }?} ,
{?{ Table1.newRow.date }?} ,
{?{ Table1.newRow.departure_time }?} ,
{?{ Table1.newRow.flight_number }?} ,
{?{ Table1.newRow.id_departure_status_option }?} ,
{?{ Table1.newRow.id_departure_passenger_action }?}
);
- Set the onSave Event:
- Set the Table widget's onSave event to run the insert query. This ensures that when a new row is added and saved, the query is executed to insert the data into the database.
- Debugging:
- Add a temporary Text widget to display the contents of Table1.newRow to verify that it contains the expected data. For example:
{?{ Table1.newRow }?}
By following these steps, you should be able to resolve the issue and successfully insert new rows into your database using the Table widget in Appsmith?7:3?source??7:3?source?.
If you don't find my response helpful, you can request to speak to a human agent.
quartz thunder
