Method:Classic General Q&A

Re: Ordered items in grid

Method_Jason — Thu, 03 Oct 2013 21:47:31 GMT

grdmunoz,

In the scenario in my previous post, I set my where clause as: where the RecordID is equal to the Value From Row, RecordID. Since I wanted to update every record selected in my loop, this was an appropriate choice.

Jason

Re: Ordered items in grid

grdmunoz — Wed, 02 Oct 2013 18:06:44 GMT

That seems to get me pretty close, I understand what you say about using max to determine the current max in the row.

I have included a section of my grid for clarification.

I need the displayLine fields to be sequentially numbered from top to bottom. (1,2,3,4,etc)

right now the problem I am having ins correctly configuring the where clause in update field in table action. If you can shed some light there I would greatly appreciate it

Re: Ordered items in grid

Method_Jason — Tue, 24 Sep 2013 20:19:06 GMT

Hi grdmunoz,

You could use a Basic Math Calculation action within your loop that will update your DisplayLine field and add one to each selected record. There are a bunch of options depending on what you're trying to do, but below I set up an action set that updates my custom PlusOneNumber field. It incrementally adds one to each new record selected in the loop, starting from the maximum number in the table.

I'm not sure if this is exactly what you mean by a 'counter'. If not, feel free to elaborate a bit more and I'll try to find a better way.

Jason

Ordered items in grid

grdmunoz — Tue, 24 Sep 2013 16:06:42 GMT

I have the need to order items differently in a grid.

I created a field, displalLIne for the table the grid uses. I have the sorting set to use the displayLine to reorder the grid if I change the numbers in the display line, that part works great.

My problem is that I am not able to add successive numbers to the rows when I loop through them. I am able to place a static value, but I do not see any way to have a counter that gets incremented while I loop through and update the display line field.

How would I maintain a counter while I am looping through fields in a table?