2 Replies Latest reply on Jun 30, 2011 1:49 PM by precociousninja

    Auto-updating auto entered calculations



      Auto-updating auto entered calculations


      I have just changed several fields which were being unused to auto enter a date based (each with a different lead time) based on when our bands have a show.

      So they look similar to this

      Show Date Send Media List  Contact Bloggers Contact guest list

      6/1/11 4/1/11 5/1/11 5/20/11

      Where you only enter the show date and the other dates auto-enter.  The problem is, all those fields used to be blank and I need them to all fill in with what their data SHOULD show. And even though I've applied the auto-enter functionality to them am i right that this functionality only applies to newly created records.  How can I fill in the several hundred old date fields with their proper information now?



        • 1. Re: Auto-updating auto entered calculations

          You are correct.

          But you can use Replace Field Contents with the same calculation as you've defined in your auto-enter expressions to update your existing records. Just do a show all records on a layout where you can get to these fields, then put the cursor into one of them and select Replace field contents. You can also first perform a find, putting = in one of these date fields to find only those records where this field is blank so that any existing data is not affected by this process.

          Since Replace field contents can modify 1000's of records in one go and you can't undo it, make a back up copy of your file before trying this so that you can recover from any mistakes.

          • 2. Re: Auto-updating auto entered calculations

            Phil wins again! 

            Thanks Phil, once again you saved the day.