jwillinghalpern / filemaker-vscode-bundle Goto Github PK

e.g. "pcount" for PatternCount. When a user starts typing "PatternC" no results show up. Ideally both would work. Using PatternCount instead of pcount for the prefix might solve this, but find an approach that consistently works for all.

• get1, get2 etc... are not intuitive, find a better way.
• Perhaps we can scope some constants to only work in the Get () parentheses

It would be nice if this project (or a companion project) used a script to build bundles for multiple editors like VSCode, Sublime, and Textmate.

Sublime uses Textmate bundles and this project is based on textmate bundles in the first place. I believe the primary difference is that this project contains all the snippets in one file instead of separate files.

since FM will automatically correct the case when you paste calcs back in to FM, we might as well allow incorrect case while editing in vs code.

Strings with a prefix like $list and ~list should not be highlighted.

I'm not sure if this is better suited for a "discussion" or as an "issue," but I decided to take this route so that you can ignore the issue in case you just want to. I imagine that use case is probably extremely narrow, but I've been teaching myself Cypher and how to use Neo4j to make graph databases.

I would still consider my uses of Neo4j to fall into the category of "bumbling around," and because I'm more familiar with Filemaker at this point, I have used that as my foundation to format and prepare queries in Cypher to go into Neo4j, that way I can (hopefully) cut down on the errors and speed up input during data entry. What I've done is to create a calculated field that puts out a query that can be copied and pasted into Neo4j. Unfortunately, because I'm concatenating so many fields, even Filemaker's support document begins to lose its utility as my eyes glaze over all of the back(forward?) slashes. (Oh, and part of the Cypher query requires the use of quotation marks and apostrophes... which is why it's such a PITA.)

As an example, here is one calculated field:
"CREATE (" & Node_Name & Node_type & " {name: \"" & Name & "\", first_name: \"" & First_name & "\", middle_name: \"" & Middle_name & "\", last_name: \"" & Last_name & "\", suffix: '" & Suffix & "', nickname: '" & Nickname & "', formal_name: '" & Formal_Name & "', racing_number: '" & Racing_number & "', gender: '" & Gender & "', born: \"" & Date_of_birth & "\", died: \"" & Date_of_death & "\", nationality: '" & Nationality & "', country: \"" & Country & "\", address_latitude: \"" & address_latitude & "\", address_longitude: \"" & address_longitude & "\", public_figure: '" & Public_figure & "', node_tags: \"" & node_tags & "\", " & Node_properties & "sources_for_information: \"" & Sources_for_information & "\", filemaker_node_id: '" & Unique_FileMaker_node_ID & "'})"

The question/issue I have, is when I use your extension in VS Code, I see two shades of red (I would attach a screenshot if I could), and the shades seem to be appearing inconsistently (between text intended for Filemaker versus literal text that would be concatenated). Is there a way to tell what the colors indicate in your extension?

P.s. To be clear, the inconsistency could be the result of my own error, as I adding new fields and running into errors.

as seen in the original bundle: https://github.com/DonovanChan/Filemaker.tmbundle

Tidy script:
https://github.com/DonovanChan/Filemaker.tmbundle/blob/master/Support/lib/tidy.pl

How can someone use this extension? what file do I need to open it with to be able to use it and get the syntax and such?

This happens when you type Get ( because the closing paren appears automatically like Get () and you're cursor is left in between the parentheses.

If you then choose one of the snippet suggestions like Get ( AccountName ), it will autocomplete Get ( AccountName ) and the close paren will be left trailing like Get ( AccountName ))

I'm not sure what kind of clipboard access extensions have, but we could use these two libraries for mac and windows:

Mac: https://github.com/DanShockley/FmClipTools
Win: https://github.com/dansmith65/FileMaker-PowerShell-Clipboard

Should say 0-9 instead of 1-9 maybe?