FM - Auto Entry Modification Data Entering When Scheduled Script Runs

Posted on 2012-08-29
Last Modified: 2012-09-05
If using a non-global field (which thus exists on every record), is there a way of running a scheduled script which modifies this field, but does not change the auto-entry Modification data and name fields?
Question by:rvfowler2
    LVL 9

    Expert Comment

    Use the replace function from inside a script. That will allow you to impact all found records with any calculation you may like at the time you run the script. Make sure you set the autoenter field to allow modification.
    LVL 24

    Assisted Solution

    by:Will Loving
    I think what Randy is looking for is to prevent the separate Auto-enter Modification Date and User fields from firing when he modifies a field in the same record. I think if you're using the Modification Date and Modification User options built into FM, then any change you make to the record is going to affect these fields. You might be able to do something by changing the Modification fields to Auto-enter by calculation and including a Case( ) to always update except when a Variable flag $DontUpdate is set in the script. However, this would require a calculation that functioned similarly to the built-in Modification Auto-enter feature and while I'm sure there is probably a way to do that, I can't think of what it would be right now.

    You might be able to keep your existing Modification fields and make a second set that is displayed to end users. Set an Auto-Enter calculation to Auto-enter whatever is in the Modification Date or User field unless the $DontUpdate flag is set. Haven't tested this but it would be simple enough to try.
    LVL 2

    Accepted Solution

    Will has it right.  Thanks for these suggestions.  The solution I came up with is to never use a non-global field (one for every record) as a flag for a scheduled script.  Instead, I assigned a script parameter and used that, but you could also use a global variable, etc.  While you would not be able to do that in every case, I was able to get rid of the field here.
    LVL 2

    Author Closing Comment

    Giving Will credit for solutions that I could use at another time.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now