QXpress Community

Edit a grid.

Go to step2 add a link (such as select)

Set the action to assigna actionresult, get value from row from field RecordID and click finish.

>The list of fields is no longer visible (step 2 for edting grid)

If you then go back and edit the action, the dropdown list with fields to get the value from, no longer has any fields available to select.

 Hey Matt,

Thanks for the steps, they alwasy help when trying to duplicate an issue.  So I was able to duplicate your issue partly.  I wasn't able to duplicate the last comment 'If you then go back and edit the action, the dropdown list with fields to get the value from, no longer has any fields available to select.'  but I was able to duplicate everything else.  I've let the programmers know and as soon as I have something I will let you know.

Mark

If i want to assign a value to an actionresult based on the row I select in a grid, should I use "get value from screen" (this is what is done in the customer list grid) or "Get value from row" (this seemed to be the logical answer, but the one I am having errors with)?

 You want to select value from screen.  While get value from row would make more sense based of the wording, the way it's programmed you are going to want to select 'Get Value from Screen'

Mark

That isn't working.

I edited the actions for the select button on a grid

Assigned actionresult from a value on screen, with the value being a field on the grid

Enter actionresult into field on screen

Nothing shows up in that screen

(I know I could leave out the assign actionresult step, but this was just a quick test, and also just trying to assign the value from the grid to a field on the screen does not work either)

Almost forgot to ask, What is the "Get value from row" used for?

 Matt,

I've broken down your two questions below.

Matt:

That isn't working.
- I edited the actions for the select button on a grid
- Assigned actionresult from a value on screen, with the value being a field on the grid
- Enter actionresult into field on screen
- Nothing shows up in that screen

Following those steps I was able to duplicate the issue, however, I'm not sure if it is a bog or not.  I'm going to find out for you, but in the mean time I do have a work around for you.  In the example below you will see that instead of selected the Customer Column from the Customer Grid, I just select the field that the Customer Column is looking at, in this case Full Name.

Matt:

Almost forgot to ask, What is the "Get value from row" used for?

After looking for this Action, I was unable to find it.  Are you sure it's called 'Get Value From Row'?

Mark

Mark,

the workaround will not work in this case. The grid is from a detached table, so the field in the grid is not listed as a field anywhere else.

QXpress_Mark:

After looking for this Action, I was unable to find it.  Are you sure it's called 'Get Value From Row'?

On the pictures you provided above, "Value from Row" is an option just like "Value from Screen" The action may have to be a link on a grid for "Value from Row" to be an option though.

 Wow, I completely missed that and was looking in the wrong section.  He's how Value From Row works.

If you are inside a Start Loop Through Table, you can access values from the current record you by Value From Row. 

So if you have a table

Record Name

1   Bob
2   Amy
3   Wendy

And you have actions

Start Loop Through Table
               Assign Value to Action Result > Value From Row > Name
End Loop Through Table

Your Action Result would be Bob, then Amy, then Wendy.  Same deal with Value from Calendar, but of course instead of looping through a Table you are looping through a Calendar.

Hopefully that helps you out.  As for the other issue, I've already sent it to the Programmers, Once I hear back I will let you know.

Mark

 Matt,

Here is the answer to your other question,

Matt:

- I edited the actions for the select button on a grid
- Assigned actionresult from a value on screen, with the value being a field on the grid
- Enter actionresult into field on screen
- Nothing shows up in that screen

Unfortunately the reason it isn't working for you, is because it's not possible.  The good news is that we do have a work around that only require 2 extra steps.

1. First you will need to assign the RecordID as the field
   
   
2. Then you want to is Retrieve the Value from the Table where the Record ID equals the ones selected
   A. Select the Correct Table (In this case the Customer Table)
   B. Select the Fields you want (In this Example the Customer Balance)
   C. Where it's equal to the RecordID Action Result
   
   
   
   
3. Next Assign the value to the field.
   
   
   
4. You are then all set.  As you will see from my picture below
   

Mark

Mark,

Thanks for the "work around" or "Feature" as the developer's would put it. I have two comments:

1) This is a bug. For the function to be called get from screen and then list all of the data fields as an options but only return the record id is either a bug or very very bad design. I understand the get from row being only for curRow in the iteration structure.

2) If someone wants to preserve the data relationship and not recalculate it everytime, they can add a "dropdown" field to the other table and then add "ref" fields for the actual fields. You can then put the recordID from the "get from screen" into this field and the other data will just magically follow it.

 Stephen,

I've submitted this to the programmers to fix.  After talking with them again about this they agree it's something that needs to be changed.  As soon as I have an update I will let you know.

Mark

 Stephen,

This appears to be fixed and you should have the ability to pull anything without the Work Around now.  If you could please test it out and let me know that would be great.  If you still having issues, give me the example and I will test it and go from there.

Mark