Submitted by David_H on 2016/04/07 19:32
Scenario:
I have a text field named "Value" with a fixed pop-up list and the options of selecting:
Value 1
Value 2
Value 3
 
I have a grid named Goals.  When I enter ANY item in the Goals grid, I want the item to receive a Value of Value 3.  What do I enter in the Value fields equation area to make that happen?
 
Thank You

Comments

Your options:
  1. If you want this to happen whenever your set Goals to true, use an autoassign: A:[Value]=Value 3
  2. In the Grid > Properties > Data, there are 2 entries for this. Either way, you'd set-up a new field which has an autoassign as above. Then enter that field in one of the 2 field list below
    1. Auto-assign field list for all TLI
    2. Auto-assign field list for all items
 
HTH !
 
Pierre_Admin
IQ Designer
 

Hi Pierre
 
Several questions, each lettered for easy answering.
[quote=Pierre_Admin]
If you want this to happen whenever your set Goals to true, use an autoassign: A:[Value]=Value 3[/quote]
A. I assume that is to be typed exactly as entered, including the “A:”?
B. Use an autoassign where?  I would have assumed in the Goals field, but am not clear from your instructions.  If you’re telling me in your subsequent instructions I don’t follow because one moment you mention the grid properties area and the next you are mentioning a new field that is required.
[quote]In the Grid > Properties > Data, there are 2 entries for this.[/quote]
Understood.
[quote]Either way, you'd set-up a new field which has an autoassign as above.[/quote]
C. Now you’ve lost me.  Why am I setting up a new field?  Am I not inserting the autoassign in the goal yes/no field, so that when goal is set to true, the autoassignment takes place?
[quote]Then enter that field in one of the 2 field list below
Auto-assign field list for all TLI
Auto-assign field list for all items[/quote]
Understood.

Here is a screenshot of what I tried.

 
 

Please help me with this one when you get a chance Pierre.  I'd really like to learn how to do this one.

Pierre_Admin

2016/04/11 17:12

Permalink

Will do !
 
[quote]
Your options:
  1. If you want this to happen whenever your set Goals to true, use an autoassign: A:[Value]=Value 3
  2. In the Grid > Properties > Data, there are 2 entries for this. Either way, you'd set-up a new field which has an autoassign as above. Then enter that field in one of the 2 field list below
    1. Auto-assign field list for all TLI
    2. Auto-assign field list for all items
[/quote]
Going back to my first answer, you must decide if you want this to happen
  1. Anytime you set the Goals field to true (be it in the properties pane, or in another grid) or,
  2. Only in the Goals grid. If this is the case, then
    1. for all items or,
    2. just TLIs (top level items)
 
HTH !
 
Pierre_Admin
IQ Designer
 
Pierre_Admin
IQ Designer
 

Pierre,
 
In your original post I thought you were giving a series of steps (1 and 2), now I realize you were giving an option  of 1 OR 2.  Based on the way I currently have my grids structured, your options 1 OR 2.2 would work for me.  However the questions in my last post still stand.
 
I've tried method 1 with no luck.  Please look at the screenshot of the Goals field in the last post and tell me what you see wrong?  Shouldn't the entry I made there have met your method #1 requirement, and anytime the Goals field is true, set the value to value 3?
 
Regarding method 2.2, the best I can make out from your statement is that I am supposed to create some new random field dedicated to achieving this, add in the auto-assign, then add that to the grid>properties>data, so that it would ONLY apply to that grid.  If I have that right then the issue is still that I cannot get method 1 above to work, so I doubt until I know what I'm doing wrong there that I'll be able to get method 2.2 to work.
 
Thanks
 
 

Armando

2016/04/11 19:09

Permalink

[quote=David_H]
Pierre,
 
In your original post I thought you were giving a series of steps (1 and 2), now I realize you were giving an option  of 1 OR 2.  Based on the way I currently have my grids structured, your options 1 OR 2.2 would work for me.  However the questions in my last post still stand.
 
I've tried method 1 with no luck.  Please look at the screenshot of the Goals field in the last post and tell me what you see wrong?  Shouldn't the entry I made there have met your method #1 requirement, and anytime the Goals field is true, set the value to value 3?
 
Regarding method 2.2, the best I can make out from your statement is that I am supposed to create some new random field dedicated to achieving this, add in the auto-assign, then add that to the grid>properties>data, so that it would ONLY apply to that grid.  If I have that right then the issue is still that I cannot get method 1 above to work, so I doubt until I know what I'm doing wrong there that I'll be able to get method 2.2 to work.
 
Thanks
 
[/quote]
 
What are value1, value 2 and  value 3?
If they are fields (but they seem to be strings since they're accessible from a dropdown list) the proper syntax is  e.g.
 
A:[Value]=[Value 3]
 
 
If they are strings you need to write:
 
A:[Value]="Value 3"
 
-
Disclaimer: "Testing IQ with the most advanced/complicated IQBase in the world". I.e. slower than average.
Windows 8.1
CPU: Intel i5 2.6ghz

Pierre_Admin

2016/04/11 19:21

Permalink

Method 1 should work, perhaps enclose value 3 with "  "
 
Pierre_Admin
IQ Designer
 

Enclosing value 3 in quotes did the trick, thank you.