Agnes Riley

I would put that JSOn in a global variable ($$JSON) and use the DataViewer to play with it until you get it right. Break down each row and see what it gives back.

I thought you are getting info from JSON, not setting it. Sorry, I totally missed that your key contains a period.

I believe it should be: JSONGetElement( $json ; ["putExpDateMap.mark"]; ["putExpDateMap.expiration"]; ["putExpDateMap.strike"] )

I have a script that runs via record creation with MBS. The script opens a new window in the main database and performs actions based on an incoming call. At times the new window opens but the main window gets/remains selected and that's where the action happens. It's 1 out of 4-5 times when this happens. I tried it with the same exact action, same result, it'll fire perfectly a few times, then in the wrong window. Any ideas?

I'm getting "The file "" could not be opened. Either the host is unavailable, or the file is not available on that host." This happens when a script runs. Not a new server, no new files. The file is actually open in the background. The file reference is just "file:". I restarted the server. Didn't fix it. FMS18.03 It's apparently intermittent. I copied all the script steps to a new script, then it worked 3 times, but couldn't find the file for the 4th time. Any ideas?

Hey Lee, Works for me. And I'm not logged in and I can view it. Some of his videos are public. Cheers, Agnes

See if this helps you: https://www.filemakermagazine.com/videos/ultimate-value-list-control Otherwise I would build a portal for users to select from. Value Lists are sort of antiquated and frustrating in FileMaker.

I think the only way is to sort your relationship in a way you want.

Dates calculate in days. So if you need to calculate a month from now you need to enter yourDate + 30 to get that. Ther are a lot of custom functions on briandunning.com if you need something more complicated.

That just dawned on me as I saw the response. 360works has great support!

Agreed. But you can use Skype or a lot of other services to make a VOIP call. You need to get their attention.

Call their phone number: (855) SEEDCODE. They are just like any other shop, sometimes busy and sometimes emails get lost in the vortex.

Yo can use a simple code in a webviewer to do this. You'll have to feed it where the bar should be at certain lines of your script. It works nicely. Alternatively you can use a button bar to do this now: https://www.soliantconsulting.com/blog/filemaker-button-bar-as-progress-indicator There's this: http://www.modularfilemaker.org/module/prbr-progress-bar/ There is also this: http://www.filemakerprogurus.com/filemaker-16-progress-bar/ Cheers!

With BE and MBS you can rename files and do all kinds of manipulation. It might take awhile to perfect things but they will work. Last I built a process when the Excel file was basically reconstructed from FileMaker and then FTPd to a server. It's crazy cool. So I don't recommend you give up. Get some help, automate what you need. :-)

Silly question, have you converted the path to BE path? There's a function for that if I remember correctly. @IdealData recommended the path change, but you haven't confirmed you did it.