Method:Classic General Q&A

Re: Retrieving values from table

Method_Valbon — Mon, 02 Apr 2012 13:37:36 GMT

Rolf,

Rolf:
When I tried to retrieve that stored value, I could choose either the field CustomerBank or CustomerBank_RecordID in the dropdown choices. Either of those choices returns the same value; namely the RecordID of the dropdown choice

Unless the fields contain the same value at the table level they should fetch different data. I probably don't have to mention this but something seems off, you can export the drop down table to confirm any values. Sounds like you have a good alternative though. I'll double check on any changes to this area just in case.

Re: Retrieving values from table

Rolf — Fri, 30 Mar 2012 20:20:06 GMT

Valbon,

I am executing a set of actions upon a text change in a dropdown field called CustomerBank. In that action set there is a conditional action dependent upon the value of the dropdown prior to the text change. That value is still stored in the table, whereas reading the dropdown field gives the new changed value.

When I tried to retrieve that stored value, I could choose either the field CustomerBank or CustomerBank_RecordID in the dropdown choices. Either of those choices returns the same value; namely the RecordID of the dropdown choice. I expected the CustomerBank field to return the text value associated with the CustomerBank_RecordID. What I've done to solve this is to retrieve the RecordID and then use that to retrieve the text value from the associated CustomerBank table.

My question was mostly about trying to understand why it worked differently than I expected and whether there had been a change in the RetrieveValuefrom Table context box.

Rolf

Re: Retrieving values from table

Method_Valbon — Fri, 30 Mar 2012 18:35:35 GMT

Rolf,

To make things easy, what's stopping you from using the retrieving for the field you are actually looking for? Using the Customer table as an example:

i.e. if you want the actual text value of the CustomerType (drop down field) than retrieve that field

or...

if you want the record ID of that value use CustomerType_RecordID

Retrieving values from table

Rolf — Thu, 29 Mar 2012 21:06:34 GMT

I am using the Retrieve Value from Table action to get the value of a dropdown field which I subsequently use in a conditional action. I seem to remember that in the past retrieving a dropdown field would automatically open a new line to allow a choice between the RegID value or the text value. I wanted to use the text value, but have found through testing that the action is returning the RegID value instead, causing my conditional to fail.

Am I missing something here?

Rolf