Solved: Can't delete/edit

Lufade · 02-06-2023 09:31 AM

I have an Employees table and a slice named Current Employees. These tables have a Department column with dropdown referencing a Departments table. The Departments table has a related employees column named "Employees1" with REF_ROWS("Current Employees", "Department") and List format.

From the preview app to the side of the editor I can add and edit records, but can not delete. From the desktop version I can not add, edit, or delete any records. The error given when trying to complete these actions is, "Action failed. Employees1 is invalid". Every table involved is set to accept updates, adds, and deletes.

If there's any other information I can provide to help determine what's going on, please let me know.

Marc_Dillon

Did you rename the auto-generated [Related Employees] column, as well as change its expression to point to the Slice instead?

I recommend "resetting" the situation here. Do this:

Delete all VCs in Department table that are REF_ROWS to the Employee table, either the base table or the slice.
Change the [Department] column in Employees table from Ref to Text.
Save the app
Change the [Department] column back to Ref
Save the app
It should auto-generate the [Related Employees] column in Department table again. Leave this column alone.
Create a new VC, with the REF_ROWS expression pointing to the slice. Also make sure to change the "referenced table" setting on this column to the slice as well.

See if that fixes some things.

View solution in original post

SkrOYC

Contact Us - AppSheet Help

Marc_Dillon

Did you rename the auto-generated [Related Employees] column, as well as change its expression to point to the Slice instead?

I recommend "resetting" the situation here. Do this:

Delete all VCs in Department table that are REF_ROWS to the Employee table, either the base table or the slice.
Change the [Department] column in Employees table from Ref to Text.
Save the app
Change the [Department] column back to Ref
Save the app
It should auto-generate the [Related Employees] column in Department table again. Leave this column alone.
Create a new VC, with the REF_ROWS expression pointing to the slice. Also make sure to change the "referenced table" setting on this column to the slice as well.

See if that fixes some things.

Lufade

Marc, that did it!

I had renamed the auto-generated [Related Employees] column and changed it to point to the slice.

I created a copy of the app and made your suggested changes in the copy, and it seems to be working exactly as expected! Looking at the original, it looks like the formulas and tables referenced were correct compared to the new app. The only difference I'm seeing is that, as you suggested, I didn't touch the auto-generated column.

Unfortunately I'm not sure why this worked, but I have an idea of what to try should I encounter a similar problem in the future. And thank you for the help!