Our Preferred 5 Star Hosting Provider - Award Winning FileMaker Pro Hosting
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #11
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    12,175
    Location
    New York and Nassau County, NY, USA
    FileMaker Pro Software
    FileMaker Advanced/Developer 14, 13, 12, 11, 10, 9. 8.8, 8, 7, 6, 5.5 FileMaker Pro 8, 7, 6, 5.5, 5
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    10-17-2017
    Local Date
    10-20-2017
    Local Time
    02:40 AM
    Last Active
    10-19-2017
    Quote Originally Posted by Jabert View Post
    Still confused. The step is not trying to change the value of a calculation. It simply wants to place the current value in a field on the new layout. Also, the value of Name~Full is fixed and never change once the calculation is made.
    You are wrong. The step IS TOO trying to change the value of a calculation.

    If NAME~LAST is blank (which it is) and NAME~FIRST is also blank, what is the outcome of this formula? Do it manually:

    NAME~FIRST & " " & NAME~LAST

    What's your answer?

    It isn't "Bernard Denis", right?

    Now watch what your script is trying to do: It goes to a record in Client Data (ID # 1123 in our previous example); in your original script you have it Copying the NAME~FULL field. The NAME~FULL field in this Client Data record happens to contain "Bernard Denis".

    Then you go to the empty record in Grid Data and you attempt to Paste. What would you be pasting? "Bernard Denis", right?

    If it allowed you to do that (which it doesn't), you would end up with "Bernard Denis" in the calculation field even though NAME~FIRST and NAME~LAST are both still empty. Do you see why that would be a violation of the formula for NAME~FULL?

    "Bernard Denis" does not equal " ".

  2. #12
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    12,175
    Location
    New York and Nassau County, NY, USA
    FileMaker Pro Software
    FileMaker Advanced/Developer 14, 13, 12, 11, 10, 9. 8.8, 8, 7, 6, 5.5 FileMaker Pro 8, 7, 6, 5.5, 5
    OS
    Windows & Mac
    Skill Level
    Developer
    Last Post
    10-17-2017
    Local Date
    10-20-2017
    Local Time
    02:40 AM
    Last Active
    10-19-2017
    Quote Originally Posted by Jabert View Post
    Just realized that I defined the fields for the target layout improperly (so much for copy/paste in creating field names, duh). So I changed all the fields in the GRID DATA layout to Text and now it works.

    I'll try notto bother you again.

    Regards,

    John
    Aah, you didn't realize it was a calc field!

    That explains a lot


    I still suggest that you ditch Copy and Paste and use Set Variable and Set Field instead. But glad you've got it working.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 3 users browsing this thread. (0 members and 3 guests)

Similar Threads

  1. Script Steps Won't Work In Calculated Field but Will In Script.
    By TravisAtSeattlePub in forum FileMaker Pro 12 - All versions
    Replies: 8
    Last Post: 01-15-2013, 02:06 PM
  2. Script steps don't always perform
    By AlaskaFilemaker in forum ScriptMaker and Scripting
    Replies: 13
    Last Post: 12-11-2012, 12:03 AM
  3. Unsupported PC Script Steps
    By qyteyy in forum ScriptMaker and Scripting
    Replies: 1
    Last Post: 07-22-2011, 06:16 PM
  4. If script steps
    By orenco in forum FileMaker Pro 8.0
    Replies: 4
    Last Post: 04-14-2006, 10:55 AM
  5. Script steps for portals
    By DanS in forum ScriptMaker and Scripting
    Replies: 5
    Last Post: 01-22-2004, 12:21 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a FREE to join community where you can boost your FileMaker expertise, build better apps & solutions and interact with over 42,000+ FileMaker Developers from all over the world. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.