And I saw it was set to Read Only. At least for the top and bottom. The middle are the date ones, they are not so straight forward. Would be nice If I could change the key on details tab to the EpiTimeEditor.
The key is a string. You have to do some extra things to make it a date-time. What are you using for your Keys?
Key 1=Reason-Alpha Characters
Key 2= STart TIme
Key 3= End Time
Key 4= Todayās date. This one Iād realy like to see auto and notup to the user.
Are the start and end times both defined when you enter the record? And do you ever need to change them? If you do I wouldnāt use those for keys. What if you have the same reason start and end for two different things? (I donāt know what you are recording so Iām not sure if itās something thatās possible or not)
These do not need to be changed. The start and end times will be for the same action. In one of our sub depts we have a machine that at times we need to break down for the next job. They do not want this as part of setup as it would give an inaccurate look at cost. Instead they want this separate. So this will be for when he starts the process and ends the process. There is only like two or three different reasons and then we have the start and end times.
While you can do what you want, if it were me, I would make the Keys less about the information and more about just making sure you get a unique row. There will always be mistakes made or anomalies that need to be fixed, and converting dates/times into strings can be a PITA if you donāt really need them to be. If you put the start/end times and the reason code as a regular fields, then you can change them later. Otherwise you have to delete the row and start over. But thatās just my opinion, you can do what you want. You know your problem better than I do.
Common things to have for keys are things like job number or maybe department. Things that if that changes itās really a different record. You can make keys unique by putting a BPM on GetNew that sets the key to what you want. (Thatās what you should do for the current date, but to do it you will need your expression to get the current date and convert it to a string.)
2 Likes
Ignore that crap I posted. I had some extra stuff going on there with child tables. This works.
Hereās what you need to set the current date on a new save.
results in this on update. (today will always say 12:00, Now will give you the actual time.
1 Like
Good Points! I honestly didnāt eventhink about unique rows. But now that you mention it, I see where you are going.
1 Like