Greetings,
I have manually put together a field calculation that formats proper geojson for my mapbox maps, this formats things fine.
Where it doesn't do what I want is in the script loop, it always gives me only one result based on the sorting.
I have also created another calculated field to list all of my other calculated fields and add the header and footer for geojson...same result, it always comes back with only one entry. Even if I try to loop another field, a text, number, whatever, still only one result.
Then I tried to export my calculated fields as tab separated text, this gives me all the calculated fields, but then it does not seem easy to inject the closing of the geojson file. The header could be added to the first record, but then how to do with the footer when the last file changes often? Another calculation ?
What am I doing wrong, and can it be done any of these ways ? Thank you in advance for any advice.
My script:
Go to Layout [ “table” (field) ]
Show All Records
Enter Find Mode [ Specified Find Requests: Find Records; Criteria: "criteria" ] [ Restore ]
Perform Find [ ] Go to Record/Request/Page
[ First ]
Freeze Window
Loop
Set Variable [ $filepath; Value:Get ( TemporaryPath ) & "file.geojson" ]
Export Field Contents [ table::field; “$filepath” ]
Go to Record/Request/Page [ Next; Exit after last ]
End Loop
Set Field [ upload::Filename; "file.geojson" ] Set Field [ upload::CurrentAccount; "account" ]
Set Field [ upload::RemotePath; "path" ] Commit Records/Requests
Go to Layout [ “upload” (upload) ] Commit Records/Requests
Insert File [ upload::Container; “$filepath” ] Commit Records/Requests
Perform Script [ “Transfer” ] Commit Records/Requests
Go to Layout [ original layout ]