Script trigger that can set field for last matched record based on field entry

[dav1089]

Hello,

I am gonna describe a scenario where total automation needed using only barcode scan, please bear with me:

I am creating operator timesheet layout for product lifecycle in list-view.

Each operator has a list of unique barcodes(printed sheet) for each production function.

Every activity(function) of print production is assigned code (barcode) that represents function type as well as operator name: For eg. if John is working on new plates function for Press he'd scan barcode 301-1 but if Marc is working on the same function , he'd scan 301-2 , Now '301' represents new plates function and number after hyphen(-) represents operator. In John's case 1 and Marc 2.

So, on the interface(list view of functions) , when an operator scans barcode of function it will set time-in field value and name of operator in their fields based on calculation from code.

I don't want STOP button for each function to set value of time-out (because it requires user interaction), rather, I want it automated.

I am looking for some sort of script trigger that runs on every new code scan and search for last record with similar operator name and set time-out value as current time in that record and set the same value as time-in for new function record. 

Thank you

 

Edited April 21, 2016 by dav1089

[BrentHedden]

**I'm writing this without any testing, so please treat this as a suggestion or push in the right direction rather than final instructions.

 

This is an old, old, old FM trick -

To retrieve the last created record, you can create a self-join relationship with reverse-chronology sort order.  The relationship will match on the operator ID.  If you were to set a field using the time-out value through that relationship, it'll pull the value you need.  

 

If the operators are scanning these multiple times per day and the FMP session doesn't shut down often or at all, then you can perhaps capture the time-out for each operator as they submit them, and set a global variable.  Then just refer to this G.V. as needed.

[dav1089]

I will give it a try and see how it works out 

Thank you @BrentHedden

[dav1089]

Hi @BrentHedden ,

I created script trigger onObjectSave for ID field but can't seem to be working :

So I created self-join relationship with operator ID as match field , but how to do Go to Record/Request to find previous record with duplicate ID .. (Do I do find record)?

I also created global to store entered operator ID and compare against self-joined occurance match field

I have done script trigger in past to find duplicate field records but , this time it is little complicated , I am also assigning value to another field.. and coming back to new record

Please help me

 

Thank you

 

 

 

 

[comment]

On 04/21/2016 at 10:48 PM, dav1089 said:

search for last record with similar operator name and set time-out value as current time in that record

I am puzzled why you need to do this duplication of data.  If every new record starts a new time period and ends the time period of a previous record with a matching value, then the end time can be got directly from the subsequent record using a relationship.

[dav1089]

 

3 minutes ago, comment said:

If every new record starts a new time period and ends the time period of a previous record with a matching value, then the end time can be got directly from the subsequent record using a relationship.

Sorry, how do I do it exactly? 

[comment]

Define a self-join relationship along the lines of:

YourTable::OperatorID = YourTable 2::OperatorID
AND
YourTable::SerialID < YourTable 2::SerialID

Place the start time field from YourTable 2 on your layout - it will show the end time of the current record.

[dav1089]

That was exactly I was looking for..Thanks @comment

 

[LaRetta]

1 hour ago, comment said:

Define a self-join relationship along the lines of:

YourTable::OperatorID = YourTable 2::OperatorID
AND
YourTable::SerialID < YourTable 2::SerialID

Place the start time field from YourTable 2 on your layout - it will show the end time of the current record.

This is one of the advantages of using a serial number over the new Get ( UUID ).

[comment]

23 minutes ago, LaRetta said:

This is one of the advantages of using a serial number over the new Get ( UUID ).

True. Although if the start times are timestamps, they could be used instead.

 

[LaRetta]

I almost mentioned using the creation timestamp.  

Particularly if the records aren't entered in start time order.

[BrentHedden]

On April 25, 2016 at 4:13 PM, comment said:

Define a self-join relationship along the lines of:

YourTable::OperatorID = YourTable 2::OperatorID
AND
YourTable::SerialID < YourTable 2::SerialID

Place the start time field from YourTable 2 on your layout - it will show the end time of the current record.

Yes, this is what I was trying to describe in my previous post.  Thanks to Comment for making this clearer.