How to set a field value based on another field value selected?

​@luizoliveira you could try using the if-else function on a form variable (I believe it works dynamically, so when your text control is populated, it will evaluate the condition):
 

The variable itself is the outcome, so you can display it in a label with whatever text you want to show depending on whether the condition evaluates to true or false. In the example above, if the value from my text box equals the value in a drop down list, then the label will show “Result: Yes”, else it shows “Result: No”
 

​@Prineel_V3 I see, I believe we’re going to figure it out :) 

I wasn’t too clear on my explanation, and I need to metion that, the field values comes from a spreadsheet as a collection. So, imagine it’s a Goolge spreadsheet with 2 columns and 3 lines:

Value 1.1  |   Value 1.2

Value 2.1  |   Value 2.2

Value 3.1  |   Value 3.2        

So, I need to get these values from the spreadsheet, extract it as a collection and set values to the controller field, as I’m already doing here:

The same must occur  to “Conta” read-only field, but this one needs to be based on the “Classificação” field, it means that if I choose “Value 1.1”, then “Conta” field must be “Value 1.2”. What I think is, if I could handle it as an object like in a programming language it would be easier, but as I need to treat it as list (collection) I’m not sure how I do it.

​@luizoliveira I think you can use the external data variables. This will allow you to query your google spreadsheet directly from the form and output the data in an object variable (you can also add conditions to the data lookup, so your condition would something like: Where column name = Classificação). You can then set the column that you need from the object into a form variable and insert it as a default value in the read only text control. You will need to create a data source/data lookup from your google connector:

https://help.nintex.com/en-us/nwc/content/designer/FormsExternalData.htm

Data Lookup:
https://help.nintex.com/en-us/nwc/content/Dashboard/DataSources.htm

Hi ​@luizoliveira,

In most circumstances ​@Prineel_V3’s solution would work.
Unfortunately, it will not work for this situation. It will not work because the Google Sheets API does not return an object as Prineel assumes.  It returns an array with nested arrays for each row.

e.g [[Make:Model],[Toyota:Crown],[Ford:Mustang]]

As this is the case, data sources can only return the first row.

The only workaround I can think of is to create a workflow that creates a Nintex Automation Cloud table with the sheet data and then uses the table as a data source.

Have the workflow run on a schedule as needed to update or recreate the table.