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

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  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 <><

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)?