Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


cjaeger last won the day on May 7 2017

cjaeger had the most liked content!

Community Reputation

3 Neutral

About cjaeger

  • Rank
  1. Hi Fenton, you can have it in calcs by converting a version 6 FileMaker file. But never touch that calc again or FM will crash. I use Field comments to store those gremlins, and insert them into Variables with GetFieldComment(). ASCII Null. Best way to access Ascii control chars is by using the sample plugin from the FMDev7.0 Disc or use free plugin http://www.jazzmedia.com.au/jazzutils.html CharToNum() Christian
  2. The characters will import fine into FileMaker, but not export the same way. Substitute(text;"¶";"<#13>") will work for example. see the XPRESS tags documentation on how to substitute literal characters with the corrresponding Xtags.
  3. You can store the images on a web server and make them show with webviever. Just store your images within your personal web sharing folder and turn sharing on.
  4. I always wrap plugin functionality by using custom functions. Basically, the Function checks wether a plugin is avalable in order of preference, and - if possible - tries to accomplish the same task with a number of Custom Functions. That way, the customer can opt for the faster plugin of his choice, but the solution will always work without as well. This saves me a lot of time rewriting my solutions and keeps the code portable. Especially a good idea when you rely on free plugins like Abstrakt's shell plug, which has not been ported to MacIntel, while a successor like Zippshell is not av
  5. Ever considered sharing the first database? Then it can be all done with clever relations.
  6. you cannto base relations on media fields directly, but portals can display related media (relation based on pic ID or file name)
  7. in FMP9 you should be able to get the User's home Directory with a status function. Include it in the path with a variable.
  8. Go to Layout based on Table 1, Import Skript Table 1, then repeat this for all the other Tables. A single Skript can have as many Import Script steps as necessary.
  9. You can copy fields (Shift-click to select) from an All Fields Layout, though. The formatting can be done easier via Format Painter.
  10. prefix your layout names in a consitant manner, click on the layout submenu and type some letters will jump to the right category. exp - Export Addresses inp - Input Names inp - Input Companies prn - Print All Data prn - Print Details with Subssummary
  11. Export your daily data as xml, put it on a webserver and run an import script when opening the runtime client . No xsl needed, just plain filemaker xml export.
  12. And if it's only one field: Evaluate( Substitute( Filter(Checkbox Field;"0123456789¶") //filter out everything but numbers and returns ;"¶";" +") //substitute returns with plus sign ) //evaluate the calc & "%" //add a percent sign
  13. Go to a Layout with all fields on it in the (tab) order desired Copy all records (using script step or alt key + copy menu command) Paste into single field.
  14. Same can be done with XML. If you use the document() function to grab the output field names and lengths from another XML file. The advantage is that you can reuse your propriatary XML format definition in other databases and applications by simply dropping the XML /Xsl files in appropriate locations and do a xml/xsl export. But then, you can buid a separate filemaker database which imports fields from your solution and subsequently exports them to the target format using the calcs described by xochi.
  15. AND - When binding the Win platform, make sure you are binding the files already bound with theMac platform, not the original unbound sources. Still you can only use one platform at a time. Runtime Apps have no networking capabilities (except Pre-Filemaker 4.1)
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.