Jump to content


  • Posts

  • Joined

  • Last visited

About vanderark1

  • Birthday 01/23/1962

Profile Information

  • Title
  • Industry
    Retail Services

FileMaker Experience

  • Skill Level
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Win 10

vanderark1's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  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 space and get this: 1A, 5B, 12A, Checkout, Checkout, Checkout, Checkout, Checkout That is exactly what I want except I want to only return "Checkout" once no matter how many times the item is at the checkout in a store. Checkout may appear zero or 1 times (so what I have works) or 2, 3, 4 or more times. I need to remove those additional occurrences. It must be done in the function (or in a script) but cannot be done in the child records. I'm sure someone smarter than me can easily see how to do this! Any suggestions would be appreciated! Thanks in advance!
  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-think this. But, SQL is putting the records in the single $$GLOBAL and the the VL portal shows them instantly while the Web Viewer does not. It seems logical to me that it's a limitation of the web viewer vs SQL. But, again, not an expert - still have much to learn and very much appreciate your input on this and everywhere on the forums (as I use info found here daily). Also - this big table has 2,326,000 records - forgot that I doubled up before my most recent testing.
  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 the portal and may be the way to go. Since I think the web viewer gives me great control over formatting plus the option to use some javascript to add features to the web viewer that I may want, I may still want to go that route. But it may come down to speed. I'm confused a bit though and I'm sure someone else knows the answer... I use a script to set a $$GLOBAL. This uses ExecuteSQL. The unstored calc in the VL table grabs the data from the $$GLOBAL - that data then appears virtually (no pun intended) in the portal whether the returned count is 2 rows or 1000 rows. The web viewer on the same layout (testing side by side with the portal), uses the $$GLOBAL and it takes 7-8 seconds for the data to appear. Again, regardless of the row count. I would think that since they are both dependent on what is set in the $$GLOBAL, that they both get that data at the same time and should show the results at the same time. Does it just take the web viewer longer to to show the data for some reason? Or am I missing something? Also - to be clear, when I had "just" 300,000 records that the data was coming from, the time difference between the portal and the web viewer wasn't noticeable at all.
  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></head><body><h1>This is a Heading</h1><p>This is a paragraph.</p></body></html> How do I enter that in my field (html_calc) to make it appear properly in the web viewer? With that info, I can then expand to add the html and css that I want, my data, etc. To clarify, I can take my global variable and set it in a script that gives me the data I want. The global var is named $$NAV.ITEM.RESULTS In the web viewer, I put: "data:text/html,<html><head><title>Data%20URL</title></head><body> " & GetAsCSS ($$NAV.ITEM.RESULTS) & " </body></html>" This puts my data in the web viewer. But, I need to control the html and css at the calculation, so I never have to change the web viewer, just the calculation, to produce new data.
  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 script to place tabs where I want but only for FM fields or text (for column headers for example). I set a dozen tabs in FM>>Line Spacing>>Tabs - one every 50 points and then used Hard Tabs n the script to move column headers (simple text) over as many tabs as desired. This works great. However, I can't figure out how to control the column width WITHIN the ExecuteSQL function. I need this, as I will end up with dozens of "reports" that I want to view in this single field, all created on the fly via scripting. Is it possible to control the tab width with the ExecuteSQL function or am I heading down the wrong path? Thanks in advance for any suggestions!
  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 installed on either PC. Filemaker's answer as recently as a week ago is that the Knowledgebase article is up to date and still valid: https://community.filemaker.com/thread/165148 This issue is making FM unusable as we can't predict it and when it happens the only fix seems to be shutting everything down, removing the FNTCACHE.DAT file and restarting. This is simply not practical. Does anyone have any ideas for a fix? Perhaps someone more knowledgeable than me could suggest something outside of FM? Maybe a Windows script that deletes FNTCACHE.DAT on login and logout of Windows? Any ideas are very much appreciated!
  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 [email protected] 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 thing I did on this solution was print to PDF - 100's of pdfs that is scripted. It's always worked fine, never had an issue until now. Does anyone have a clue on what caused this? Why these .tmp fonts are in the font menu? How do I fix it? Disappearing theme?
  • Create New...

Important Information

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