Method:Classic General Q&A

Re: No rows selected error/conditional warning

Method_Paul — Thu, 04 Oct 2012 17:26:33 GMT

FYI - planned date for the October version hitting the staging site is October 25th.

Paul

Re: No rows selected error/conditional warning

LaCrews — Thu, 04 Oct 2012 17:06:32 GMT

A big thanks.

Re: No rows selected error/conditional warning

Method_Paul — Sun, 30 Sep 2012 19:17:33 GMT

@LaCrews, and anyone watching this thread:

The "October Version", when it comes out, will have an advanced option for "Start Loop Through Grid" called "Suppress warning when no rows are checked". This will default to off. If you turn it on, then when there are no rows selected, Start Loop Through Grid will use continue on and ignore that fact that it looped through 0 rows, and not warn you.

Paul

Re: No rows selected error/conditional warning

LaCrews — Thu, 05 Jul 2012 15:17:52 GMT

Thanks Chad. I had also mentioned this to Val at Scaling New Heights.

Re: No rows selected error/conditional warning

Anonymous — Thu, 05 Jul 2012 14:58:58 GMT

LaCrews:
We're currently using a series of checkboxes for user to indicate whether a grid is included or not.

I've put a request into my team here with your suggested changes to the Loop Through Grid action - I can't say when or if this will make it into Method but I'll keep you updated.

Re: No rows selected error/conditional warning

LaCrews — Wed, 04 Jul 2012 21:21:02 GMT

Chad

We're currently using a series of checkboxes for user to indicate whether a grid is included or not.

Re: No rows selected error/conditional warning

Anonymous — Wed, 04 Jul 2012 21:08:32 GMT

LaCrews:
In addition to the current conditional warning would it be possible to have a new action that tests for whether a grid has any rows checked?

I can ask the team about your request and see what they say.

I will say the Loop Through Grid functionality is correct and I think re-working part of your action to take out any actions that don't need to run in the loop would be best. If you put those actions into an event and used the Call Another Action Set action you could conceivably call that action inside the loop (where it is now) and again from somewhere else. You're still stuck with the problem of a conditional warning and the loop not running when there are no checked rows so you'll have to rethink things here.

Is there any chance you can adjust your process to run on all rows and maybe use filters and selection lists to filter on the fly?

No rows selected error/conditional warning

LaCrews — Wed, 04 Jul 2012 19:03:41 GMT

Currently when using a grid loop action for selected rows if no row is selected an automatic conditional warning shows and no other actions get processed.

There are a number of circumstances where not completing the action set is problematic. For example, when creating an invoice from billable time and expenses from more than 1 grid, sometimes a grid deliberately has no selected items.

In addition to the current conditional warning would it be possible to have a new action that tests for whether a grid has any rows checked? This would allow us catch and handle the error before Method does.