Jump to content
Sign in to follow this  

Values left out if I include a Sort Script in my Script. Not sure why it is doing that

Recommended Posts


I've decided to start a new thread as I think this is now a different problem from my last post.

I've located my problem; but I'm not sure how to fix it.

I have a script that will take the values from a certain field from my RunSheetLines table and then it will Set Field in another layout.

When I disable or clear the sort function from my script, the variable will take all of the values from all of my desired RunSheetLines.

But when I introduce a sort (I need to sort according to Date and then Time), some of the values from all of the RunSheetLines fail to be carried over.

I can't seem to figure out why it is doing this, nor how to fix it.

I would appreciate any help with this very frustrating problem...

Thank you

**Edited Addition: I've narrowed it down to the RunSheetLineDate field. For some reason when the Date of the RunSheetLine is earlier than the EventDate it fails to be carried over.

I can't think of why this would prevent it from being carried over. I've tried taking off auto enter for this Date field, but it is still not solving the problem.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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