I am using the delete multiple rows feature for the first time (yup, didn’t realize it had appeared!). My question is: If the relation is empty, will the action be forbidden, despite subsequent steps being possible? See screenshot. I want to delete the parent row in a table and all the related children rows. So in step 1 I delete the multiple child rows using the relation. Then in step 2 I delete the parent row. However, I 'm concerned that if the parent has no children then the action will not be allowed and the parent will not be deleted. Or will Glide just skip the first step since it is an empty relation and execute the second? I have noticed that sometimes buttons are not visible when the corresponding actions are not possible. [image]

The way to do this is as follows: Delete Row (children, via relation) Wait for condition (relation is empty) Delete Row (parent) The wait is important, otherwise you risk the parent being deleted before all children are gone (and hence breaking the relation), leaving one or more orphans. As to what will happen if the initial state of the relation is empty, I’m not sure. But it will be easy enough to test that to find out. Worst case, you would just need a condition at the start of the action - one branch to deal with each initial state of the relation.

I have a similar scenario where I Set Column values in a couple of tables through relations. Those actions are among others that need to run regardless if the relations are empty or not. If those relations are empty, the entire button disappears. [image]My Hard Stops and Annoyances I perform some actions through a Single Relation, such as a Set Column Action. This action is among other actions in a custom action that sets some values in the current row as well at rows in other tables before executing a Show Detail Screen action. I noticed that the button completely disappears if one of the single relations are empty. If there are no matches in the relations, then there is nothing that to needs to be set, but there is no reason why the rest of the action sequence can’t continue to run. I still need those other actions to occur but the button completely disappears. Short of breaking a single IF branch in the custom action into 3 or 4 separate branches to account for every possible scenario, I see no reason why the entire button needs to be disabled. This was not an issue in classic apps. I did the same thing and the button still worked as expected. This is only an issue introduced with New Apps. Notice the highlighted actions. The relations for those actions may or may not be empty. If they are empty, who cares…the rest of the action sequence should work, so there is no reason to hide the button that calls this custom action. I’ll have to add 3 extra branches just to account for the times that one or both of the relations are empty and duplicate a lot of logic. [image]

Agree. I think the logic should be to skip a step in the action when the relation is empty, not invalidate the whole action. I have used Darren’s tip with the if else branch for the childless scenario and a wait for condition (relation becomes empty before deleting the parent) for the other, with a 3 second time out. I hope that works!

Nice didnt know we could delete multiple rows now!

This has actually been possible for about a year and a half. [image] new Deleting multiple rows from a delete action Ask for Help [image] It has finally arrived.

[image] Joe_Gabriele: Nice didnt know we could delete multiple rows now! [image]

Hahaha, never really had a use case. Dont know what you dont use! :rofl:

Deleting multiple rows - nesting

Ask for Help

Jeff_Hager March 5, 2024, 4:45pm 7

This has actually been possible for about a year and a half.

Topic		Replies	Views
Error deleting rows Report a Bug	13	224	May 17, 2024
Deleting rows from multiple related tables Ask for Help	8	823	March 24, 2023
Options for cascading delete Ask for Help	7	803	May 12, 2022
Delete multiple rows Report a Bug	1	64	March 27, 2026
Delete multiple rows via button Ask for Help	5	818	February 14, 2024

Deleting multiple rows - nesting

Related topics