Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


LaRetta last won the day on May 8

LaRetta had the most liked content!

Community Reputation

495 Excellent


About LaRetta

  • Rank
    Lifelong FM Student

Profile Information

  • Title
  • Industry
  • Gender
    Not Telling
  • Location

FileMaker Experience

  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    High Sierra

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. LaRetta

    Shortcut to move through layouts?

    Hi Lee! I love the 'banana man' ... here is a link to the 'Product Enhancement' request: https://community.filemaker.com/ideas/3192
  2. LaRetta

    Shortcut to move through layouts?

    I had originally tried all the key combinations to no avail. But when you said it worked for you on Windows AND the keystroke tiled the windows on my desktop, I realized it might be a Mac shortcut being applied instead. Yep, I won't hold my breath on getting that functionality back, unfortunately, although I will send in that suggestion. My cat? Oh, I really LOVED that avatar but I got tired of it. Even the best things can become tiring if exposed constantly over long periods of time (maybe not true for ice cream). I'll bring the cat back though ... it always makes me smile. 😎 Thanks again for helping me, Steve!
  3. LaRetta

    Shortcut to move through layouts?

    Hi Steve, thank you for the idea! If I uncheck Application Windows in my Preferences, which uses Ctrl+down arrow, that works! I was about to give up but realized that maybe a pre-assigned shortcut was interfering! And we can count the layouts with: ValueCount ( LayoutNames ( "" ) ) Of course we shouldn't have to do either of these if they would have left the record indicator alone. I hope FMI fixes that issue; it's not like the Status Toolbar is overly-crowded. 😃
  4. In prior versions, we could 'scroll' through our layouts in LayoutMode using the record indicator. It also displayed the number of layouts. That seems to have gone to cyber heaven. Does anyone know of a shortcut I can add on my Mac to the Application shortcuts to move through the layouts? Or am I just not spotting that functionality yet? 😀 Hey Stephen! Thank you for adding all the cool emoticons to FMForums!
  5. LaRetta

    Export Field Contents and Automatically Open

    Hey everyone, is there any way in newer versions of FM to preview and save a PDF stored in a container from Web Direct? I can Export Field Contents to temp directory and automatically open and it works fine on desktop but Web Direct only allows me to save it (ADDED: but not preview it). I'd like the option of Preview without having to worry about a User's browser settings. Matt Klein said, "If I could just bother you for one more bit of confirmation......if "Allow progressive downloading" is marked, then the interactive container data is sent from WebDirect to the browser using unencrypted/secure HTTP, but if "Allow progressive downloading" is NOT marked and "Require secure connections" IS marked, then the container data is sent from WebDirect to the browser using encrypted/secure HTTPS. It just wouldn't be interactive. Is that correct? We have SSL checked but not Allow Progressive Downloading since it is not secure (from what Steven Blackwell and Wim says). Is that still true today? This post is from 2014.
  6. LaRetta


    Considering OneStop's request, an unstored calculation which needs to compare every record in the same table using DISTINCT, particularly if any record is open, would be a resource nightmare as I suspect he discovered. But why not simply create a script which uses that same single ExecuteSQL() step after making sure the record isn't open? Via script is the only way I ever use *ExecuteSQL(). Ah well, I shouldn't have stepped in since I didn't take the time to read the entire discussionl. Thank you for clarifying, Olger! * and yes, there are always exceptions such as a smaller or single-record tables.
  7. LaRetta


    The point is that creating a calculation field using ExecuteSQL() is not recommended.
  8. LaRetta


    Hi Barbara! As I explained, I really haven't followed this thread and was simply making an observation about Tom's mention of ExecuteSQL() in a calculation and Josh's mention of using a looping script. Depending upon the need, I thought PSOS was a good mention here. Nice to see you!
  9. LaRetta


    You took the words right out of my mouth, Tom. Unfortunately, I hadn't had the time to follow this thread as I'd liked. Wim explains it very well below, link here https://community.filemaker.com/thread/149215?start=0&tstart=0 (although the entire thread is well worth the study). OneStop, you're lucky to have such great assistance. This is why I still ask questions here as well. :-) My apology for not reading the entire thread so I'll only suggest that using Perform Script on Server is lightening fast if you can use it. I'm still blown away at the speed differences. Agnes, you've been quite helpful and respectful throughout. This forum is lucky to have you assisting.
  10. LaRetta

    Move characters

    Not quite. OneStop, you'll need to search for *-
  11. Hi Steve, There would be no reason to make this stored data unless the User needs the ability to change that date. Making it a stored calculation is better option. :-)
  12. We would need to see your file. We can't give a solution with no information on how you are structured. Did you search here for scanner scripts as I suggested?
  13. I am not available right now and it looks like you have lots of good help. Also, I simply have never used a scanner so I would hesitate in assisting with the scan portion. I only have one suggestion for you at this point: do not rush this decision. Be sure this step gets you closer to a structurally-solid solution. Changing a structure later on (once it has business data) is much more difficult than designing it properly in the first place. Really, I again suggest you create a record with the scan. You can search here on FMForums; I know there have been many examples presented on scanning and creating records. Hang in there. FileMaker is fairly easy to learn but it still is not simple; particularly an inventory process.
  14. I see Dan responded about searching but I had created this sample file showing how you can add or decrease values in any number field using Show Custom Dialog[]. So once you've found your desired record, the user action of selecting it will pop up a dialog. However, it usually works better to use RECORDS to add or decrease a field's value because that will allow a history of the changes. If you simply change a field, you will never know when it was changed, who changed it or its prior value. You would completely lose your audit/history trail and if a mistake happens, you'll never know how to switch it back. Using a related table showing an 'adjustment record', or even adding a record in the same table might be better approach (we have no reference of the purpose so it is difficult to provide more definitive answer on where the adjustment record should be created). If you wish to explain the purpose of this action, we could help you pin it down further. I hope between Dan and I, we've helped you move forward on your request. :-) AdjustAmount.fmp12
  15. LaRetta

    Change hover style on fields in read mode

    Hi Tamanna, welcome to FMForums! You haven't indicated your FM version or OS. Please complete your profile since it can make a difference in what we recommend. Please see attached (you must be signed in to download it). You can select your portal (in layout mode). From Inspector, select the third tab (styles). Pop open popover of portal to show portal row. Pop open the next popup and change to 'hover' and change the fill to yellow or your color choice. I realize this isn't changing the FONT but won't this work instead? test.fmp12

Important Information

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