It's maybe just as inelegant as your 'manual' solution, but if you named the fields as objects, the 'Go To Object' can be directed by an incremented variable. I recognise you will have to name 150 objects
Thanks for taking a look at the problem Sorbsbuster, that does seem to be the only way - though as far as I can see, I'll still need an approach to store each line as a unique variable. Which means also writing the name for each field manually too...and which seems unnecassarily cumbersome..
I am working through learning how to get the field name and use it as a $$name for the contained data, and I cant help but feel that this could be the answer for directing to a field as well. Any suggestions much appreciated!
Well, I have a big leap forward: I found thesupportgroup.com had worked around a similar problem - and with loads of effort I now have a script to write variables based on the name of the field - which actually works so far! With some exit lop paramaters etc I should have what I needed for the variables.
Now to see if I can use the same approach for navigation to each field...if my forehead can stand it...running out of bandaids...
Heres the script for any interested:
Set Variable [$n; Value:0]
Set Variable [$n; Value:$n+1]
Set Variable [$varName; Value:”$$Line” & Right (“0” & $n;2)
Set Variable [$varValue; Value: Get(ActiveFieldContents)]
Set Variable [$setNameandValue; Value:Let ( [variableName = $varName ; variableValue = $varValue ; formula = "Let ( variableName = variableValue ; \"\" )" ] ; Evaluate ( Substitute ( formula ;[ "variableName" ; variableName ] ; [ "variableValue" ; Quote(variableValue) ] ) //close Substitute ) // close Evaluate) //close Let
Go to Next Field
Cool hey - (well to the filemaker newbs like me..)?!
Having jumped in the deep end of the Filemaker pool, the sharks have begun circling!
In the above script I now have a list of incrementally named variables with values, however I am now stuck on parsing the values incrementally to the sort section of the database...
I thought I had a handle on the $setnameandvalue variable script step, but cant get my head around how to step through it again without changing the contents of each variable.
I should also point out I am guessing a lot of how many of the functions actually operate, so feel free to point out the whole approach is daft
Any thoughts would help preserve what little remains of my sanity.....if there ever was any.....