Welcome, Guest. Please Login or Register.
eccoMAGIC Forums
06/26/22 at 03:18:45
Home Help Search Login Register


Pages: 1
Send Topic Print
  Rating
Rate:
Rating:
Rating: 0.00
Votes: 0

5
4
3
2
1












5
4
3
2
1


1


2


3


4


5


6


7


8


9


10

Set Column Value based on Other Column Value (Popularity: 7868 )
ScottSutherland
EccoMagic Apprentice
*


I Love Ecco!

Posts: 9
Show the link to this post Set Column Value based on Other Column Value
06/07/10 at 12:08:40
 
Greetings!
 
I've set one or two folder rules based on samples, so I am very inexperienced at it.  I really don't have time to try to learn all the syntax of rules or LUA, and I'm not even sure which to use.  I'm hoping that somebody who knows this stuff really well can take a few seconds or so to help me set something up.
 
Here's what I have (related to this problem):
 
A pop-up list called "Site" with several different values.
A "Net Location" column
 
Here's what I need to do:
 
If the value of the Site column is "DWP", I want the Net Location column set to "C:\Users\Scott\Documents\Websites\DurableWoods\DurableWoods.com\index.php"
 
Once I know how to do that, I can set it up to put different values in the Net Location field, based on different values in the Site field.
 
Thanks in advance!!
 
Scott Smiley
Back to top
 
 

______________________

Scott Sutherland
http://DigitalProminence.com
"Because Your Digital Presence Matters" TM
Email   IP Logged
Admin
Administrator
*****


I love Ecco!

Posts: 127
Show the link to this post Re: Set Column Value based on Other Column Value
Reply #1 - 06/07/10 at 19:35:58
 

maybe start here: http://forums.eccoMAGIC.com/forum/YaBB.pl?num=1195222863/2#2
 
 
also look at http://eccowiki.com  and see examples, etc...
 
 
Back to top
 
 

The Administrator.
WWW   IP Logged
ScottSutherland
EccoMagic Apprentice
*


I Love Ecco!

Posts: 9
Show the link to this post Re: Set Column Value based on Other Column Value
Reply #2 - 06/08/10 at 12:41:15
 
Hi!  Thanks for the response, but I'm still feeling pretty lost.  I'd already viewed the stuff in the Wiki, so that wasn't very helpful to a rookie like me.  The imatch function looks like it might be what I need, but I'm at a loss as to how to make it look at the value in "column a", and set the value in "column b" based on what it sees in column a.  If you (or anyone else) is familiar with the functions & syntax, could you just show me the code that would do this:
 
If columnA="ABC" then columnB="123"
else
If columnA="DEF" then columnB="456"
else
If columnA="GHI" then columnB="789"
endIf
 
I'd be most grateful Smiley  I'm pretty good at understanding how things work based on examples I understand, but I've yet to find an example that does the whole "set column value based on another column value" thing.
 
Thanks!
 
Scott <><
Back to top
 
 

______________________

Scott Sutherland
http://DigitalProminence.com
"Because Your Digital Presence Matters" TM
Email   IP Logged
Admin
Administrator
*****


I love Ecco!

Posts: 127
Show the link to this post Re: Set Column Value based on Other Column Value
Reply #3 - 06/09/10 at 16:35:42
 

1. find the IFF( )  command on the wiki.  You can use it compound eg,  
 
++:+!: iff(gfv("folder1") = 3,"MATCH",iff(gfv("folder1" = 4,"MATCH4","NO MATCH"):[folder1]
 
 
but easier to use above link example for indexed lookup.
Back to top
 
 

The Administrator.
WWW   IP Logged
ScottSutherland
EccoMagic Apprentice
*


I Love Ecco!

Posts: 9
Show the link to this post Re: Set Column Value based on Other Column Value
Reply #4 - 06/10/10 at 11:44:12
 
Thanks again!  Help me with your example.  Each reference to a folder is "folder1".  So how does that look for something in one folder (column) and set a value in a DIFFERENT folder (column)?
Back to top
 
 

______________________

Scott Sutherland
http://DigitalProminence.com
"Because Your Digital Presence Matters" TM
Email   IP Logged
Admin
Administrator
*****


I love Ecco!

Posts: 127
Show the link to this post Re: Set Column Value based on Other Column Value
Reply #5 - 06/10/10 at 16:23:54
 

 
auto assign rule in any folder sets the values for *that* folder.
 
so if rule is in folder 2  it can set value based on folder 1.
 
 
suggest again to look over the tutorials on the eccowiki.
 
 
start with something simple,
 
folder1  with rule ++:!+:[folder2]:[folder2]
 
and then see what happens when you add values to folder2 for different items.
Back to top
 
 

The Administrator.
WWW   IP Logged
Pages: 1
Send Topic Print