MS Visual Studio Code

1

I’m going in and tweaking a lot of SQL statements and wondering if there’s any new/easier ways to integrate MS Visual Studio Code with Filemaker, or if it’s a copy-paste round trip. I know at one point @jwilling made an extension for Visual Code Studio for FM, but it's still clunky to get code there and back.

2

Round trip is gonna be tricky and probably involve some UI/macro automation. Just a brainstorm:

When viewing a calculation in FM you could do an applescript that:

  1. cmd A + cmd C to copy all
  2. open vscode and focus that window
  3. cmd N for a new tab
  4. cmd v to paste the fm calc there
  5. some automation to set the programming language to FileMaker from the dropdown

Going back the other direction from VSCode to FileMaker would be hard to make robust, but if you leave the calc window open, then some automation could

  1. confirm you're focused on vscode
  2. select all and copy
  3. focus on the filemaker window
  4. optionally confirm a calc dialog is open? There's a FM-applescript reference book somewhere.
  5. select all and paste to overwrite
3

I'm still using cut/paste in both directions. Moving in any direction only takes a fraction of a second but if you find something better let us know.

1 Like