I have often needed to set a specified field's value. Or even go to a specified field. The problem is I need to set or go to a field based on a calculation. Is this possible with smartpill?
Thinking about it, it seems that I could use the new SQL functions to do this. I am working on it using the examples in the testbed file. Any additional ideas would be greatly appreciated.
If you're talking about simply getting data back into FM after calculating it in PHP you're exactly right, it's easily done using the SQL features of SmartPill 1.5. I'm using it to drop data back into FM that gets returned from web services. Works great!
Maybe using New SQL functions?
Thinking about it, it seems that I could use the new SQL functions to do this. I am working on it using the examples in the testbed file. Any additional ideas would be greatly appreciated.
yup
If you're talking about simply getting data back into FM after calculating it in PHP you're exactly right, it's easily done using the SQL features of SmartPill 1.5. I'm using it to drop data back into FM that gets returned from web services. Works great!