Jump to content
Sign in to follow this  
kenneth2k1

Find New Records Entered During Session

Recommended Posts

I have a problem:

I want to be able to display those records that I have entered during the current session. In other words, I would like to filter the records down to those that I input from the time I opened FM Pro that day. What I'm trying to do is select this group so that I can print letters for them at a later time, without printing each individual letter at the time I enter the record.

Right now I am using a button that omits the record after I input it, then going to the layout I want and hitting another button that shows omitted records. The drawback to this is that once I omit the record, I cannot see it until I have it show omitted records, so this is not a very good idea.

But I know that there are many very knowledgeable people in this forum that can help me!!

Thanks all

Ken

Share this post


Link to post
Share on other sites

Create Date as an autoentered value, then find on those records whose creation date is equal to today or the date in question.

Share this post


Link to post
Share on other sites

This solution – using the date – will work, but only if you see one day as one session. If you want to have more than one session per day and keep these records separated from each other then you need to still use an auto-enter value, but calculated and not just the date.

One way of doing this is to have a script at startup set a global field to Date plus session number, so; <28.09.2001 01>

Use another script to manually change the session number if you need to. You can use scripts and calculations in thousands of ways now, to change the session number at given points, or at each new start etc.

Rigsby

Share this post


Link to post
Share on other sites

Another solution, not as clean but should work, would be to create a field

CurrentSession which would be auto enter to a value such as "X" and either have the script you use to search for the current session's records or your close script to reset this field to " ".

Show All Records

Replace [ CurrentSession, Replace data:Calculation: , "" ]

Share this post


Link to post
Share on other sites

Very insightful, thanks Kurt and Rigsby. I'll have to decide which is more beneficial for me. I think daily will be sufficient, but I'll have to see how it goes.

Thanks again!

Ken

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.

Guest
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.