Jump to content

Default value from previous record


This topic is 5678 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I'm working on a task recording system. I have a master or header table that contains information for a support call, then I have a related detail table (in a portal) that contains records for things like: travel to site, on-site, lunch, break, training, etc.). This table has fields for start time, end time, and elapsed time.

What I would like is for either the start time for one record to automatically be put into the end time for the previous record, or for the end time for one record automatically be the start time for the next record.

Is there a calculation function that I am missing? I've looked at using a global field but I can't find a way to get the value into that field without using a script.

Link to comment
Share on other sites

This is possible using a self-join and an auto-enter calc, but exactly how depends on what you mean by 'previous record'.

In a multi-user solution, the previously created record in the table could have been created by a different user. So a simple self-join based on all records may not be a good idea. In this case, the self-join can be filtered by the current user, or whatever. Then the auto-enter calc can be something like:

Start Date (auto-enter calculation) = last(Self-join by User::End Date)

Link to comment
Share on other sites

This topic is 5678 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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