Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About vanderark1

  • Rank
  • Birthday 01/23/1962

Profile Information

  • Title
  • Industry
    Retail Services

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10
  1. Looking for a bit of help with the LIST and Substitute functions (I think). Grocery Store mapping application. An Item is in multiple locations in a single store. Item: ABCD is in locations 1A, 5B, 12A and at all the Checkouts (in this example, 5 checkouts) The table ITEM is the parent and the child table is SKU (which is all occurrences of an ITEM in a STORE) Using List, I get this for Item ABCD 1A 5B 12A Checkout Checkout Checkout Checkout Checkout Nesting the list in Substitute to change the RETURNS to COMMAS and a trailing s
  2. I'm trying to cut down on the complexity of the Graph. The table with the 1,000,000 records is not related to any other TO in the Graph currently. My reports (that I show in the VL portal and/or web viewer) pull from multiple tables A relationship from the big table to the others isn't needed except for these reports. SQL seems to work very well for that - keeping the work in scripts and not in managing the Graph. I foresee a ton of TO's needed if I try to grab the data needed for the reports. I'm no expert however, so if SQL is going to be the drag on speed, then I may need to re-th
  3. I've been testing quite a bit. Created a text environment with a little over 1,000,000 records. The virtual list returns data to the portal instantly while using a Web Viewer is taking about 7-8 seconds to get the results in the viewer. I feel that I have better control over formatting with the Web Viewer but could ultimately have 5,000,000+ records in my live solution so speed is a factor for sure. Bruce - thanks for your file. I need to dig in and figure out HOW it works (though I obviously see WHAT it is doing) as it looks to give me much more control over the virtual list field in
  4. Comment, you very simple code got me going correctly. I need to brush up on HTML and CSS to get it how I want, but it got me over the hump. Wim, I did look at the specific table in the link to Soliant (found it last night in another post you made). I was pretty lost after looking thru it. But now I think it will start to make sense after work thru the basics of using the web viewer. Thanks to both you!
  5. After some testing, I think the web viewer is the way to go for my solution. However, I'm having a hard time figuring out exactly what syntax to use in my calculation field that will be placed in the web viewer. Everything I find while searching seems to assume that's already known. This is extremely basic, I know. However, I've never worked with FM's web viewers. So, I need to put a calc in the web viewer. My calc returns text: html_calc Assume I want the most basic of basic from W3School: <!DOCTYPE html><html><head><title>Page Title</title>&
  6. I will look into these suggestions, thanks. It just seems obvious to a beginner (at SQL) that there should be a way to control the column width via the ES code, unless that's outside the scope of ExecuteSQL and can be done in SQL.
  7. I have created a "viewer" using a virtual list technique and ExecuteSQL. The "viewer" is a portal that contains one field - a unstored calc text field from the virtual list table. This allows me to run a script for a "report" and have the results appear in this field. I can run a different script and have different data appear in that field. Everything works great, except column widths. I understand how to adjust Tabs, alignment, etc using FM>>Line Spacing>>Tabs. However, that sticks to the field regardless of the data it is showing. I can use hard tabs in the scr
  8. Thanks Josh - I did create a batch file that runs at startup to delete the .tmp file. The thing is, that file shouldn't be there. Not sure if it will help until I get the issue again. FM says it's Adobe's issue - Reader (and full Acrobat since that's what I have) isn't deleting the .tmp file. I haven't seen it affect any other app, but FM says it does. It happens in my solution and in demo solutions I downloaded today - so I don't think it's related to my particular solution.
  9. This pertains to a known issue with FM on Windows, where the fonts in a solution change to a .TMP font due to printing to PDF. https://help.filemaker.com/app/answers/detail/a_id/15419/ I posted about this issue a long time ago, got the fix from the FM Knowledgebase (delete a file and restart). That fixes it temporarily - but it returns about once per week or two. I upgraded to FM15 hoping that would fix it for good, but it's happening again. I use FM15 Advanced, Windows 7 Professional, Acrobat X (and XI on another PC - it happens on BOTH). I don't have Adobe Reader instal
  10. Hopefully the final issue on this.... The theme I was using for ALL the files (Classic under the Basic group) is gone in some of the files. It's still there in others. How do I get it back in ALL files? According to FM, you can't import a theme from one file to another if it's a theme that ships with FM - which this is (and it doesn't appear when I try to import). I had FMP14A repair my installation, hoping it would put back the theme that's obviously missing or corrupted. Any ideas? Thanks in advace!
  11. I am running Windows 7 Professional and Filemaker Pro Advance 14.0.2
  12. OK - that worked. Of the 3 workarounds suggested by FM, I deleted the Font Cache file. I don't use Adobe Reader (not installed) so I can't update it. I did try to update Acrobat XI - but I already had the latest. I'm not using anything other that 100% zoom. So, deleting the Font Cache file worked. I just wonder if that's temporary - going to happen again I think...
  13. Thank you! I also found that it is a known issue. The very same file DOESN'T have the issue when I move it to my laptop - only happens on my PC. So I dug some more and found this: https://community.filemaker.com/thread/85958?start=0&tstart=0 https://help.filemaker.com/app/answers/detail/a_id/15419/ I'm running the suggest workarounds now...
  14. Correct. Used the files on my laptop, closed them. Today, opened and all are like this. This is probably important - I store the folder on Dropbox. I don't host the file as I use it only by myself. I move it from home to laptop to office now and then and to do that, store a COPY in Dropbox. I always keep the last one I'm working on on the device I moved it from. So, I checked the version on my laptop and it's perfectly fine.
  15. FM14 Advanced 14.04 I have a solution with about 15 files. All use the same Theme - Classic under the Basic group. I use the default font (Arial). Today, I opened every file and every one has the font set to Z@R34F1.tmp I checked the theme and they are all still using Classic under the Basic group. So I tried to change the theme. As soon as I do, in any of the files, the Classic theme is gone in the menu. At the bottom of the font menu are 5 or 6 of these same fonts with slightly different letters. Digging tells me they may be Adobe PDF related? The last thi
  • Create New...

Important Information

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