how to lookup the ID number & patch result

[Anonymous]

Hi All,

I am struck here, 

when 1st time i patch it will create registry of operator name, machine, reason & start time

when patch is pressed for 2nd time it lookup the ID no & patch the finish time

at the moment i used this code & it is not registering any other registry if once the operator name & machine is used, if i choose another reason for same operator its not registering any entry. because same operator same machine but with different down time reason registry is possible.

If(
   IsBlank(LookUp(Downtime, Operator.Value = Operator_dropdown_2.SelectedText.Value && Machine.Value = Machine_dropdown_2.SelectedText.Value)),
   Patch(                           // Add new registry
         Downtime,
         Defaults(Downtime),
         {
           Operator: Operator_dropdown_2.SelectedText,
           Start: Now(),
           Machine: Machine_dropdown_2.SelectedText,
           Reason: Reason_dropdown_1.SelectedText
         }
   )
,
Patch(
             Downtime,
             LookUp(Downtime, Operator.Value = Operator_dropdown_2.SelectedText.Value && Machine.Value = Machine_dropdown_2.SelectedText.Value),
             {
              Finish: Now()
             }
)
)

can you help me please what formula to use?

any help is highly appreciated

[v-jefferni]

Hi @Anonymous ,

Could you please share more details about your scenario?

Do you mean when in a day (I presume) click the patch button:

1. If Operator and Machine selected already exist in one registry but with different reasons, patch a new registry;
2. If Operator and Machine selected not exist in one registry and whatever the reason is, patch a new registry too;
3. If totally same Operator, Machine and reason in a line, update a registry with the finish time.

Anyway, only when selected Operator, Machine and Reason could be found in one registry, click the button and update the registry with the finish time.

If so, the formula would be modified to:

If(
    IsBlank(LookUp(Downtime, Operator.Value = Operator_dropdown_2.SelectedText.Value && Machine.Value = Machine_dropdown_2.SelectedText.Value && Reason.Value= Reason_dropdown_1.SelectedText)),
    Patch(                           
         Downtime,
         Defaults(Downtime),
         {
          Operator: Operator_dropdown_2.SelectedText,
          Start: Now(),
          Machine: Machine_dropdown_2.SelectedText,
          Reason: Reason_dropdown_1.SelectedText
         }
   ),
   Patch(
         Downtime,
         LookUp(Downtime, Operator.Value = Operator_dropdown_2.SelectedText.Value && Machine.Value = Machine_dropdown_2.SelectedText.Value && Reason.Value= Reason_dropdown_1.SelectedText),
         {
          Finish: Now()
         }
   )
)

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution  to help the other members find it.

[Anonymous]

Hi @v-jefferni ,

Super. Many thanks the formula works good and making all the registry for the 1st time choosen downtime reasons.

but lets say, if i want to register breaktime twice, in this case its not working. example we have 3 times break in the 8 hr shift. so break will be registred thrice. is it possible to register reason more than once by the same operator & same machine?? 

Please let me know your opinion.

Thanks in advance!

[v-jefferni]

Hi @Anonymous ,

I'm not quite clearly understanding your purpose. Do you mean with same operator & same machine & same reason then register a new line with a start time?

If so, you will need to add a condition in If statement which supposed to be:

If(
    IsBlank(LookUp(Downtime, Operator.Value = Operator_dropdown_2.SelectedText.Value && Machine.Value = Machine_dropdown_2.SelectedText.Value && Reason.Value= Reason_dropdown_1.SelectedText && !IsBlank(Finish))),  //Add condition !IsBlank(Finish)
    Patch(                           
         Downtime,
         Defaults(Downtime),
         {
          Operator: Operator_dropdown_2.SelectedText,
          Start: Now(),
          Machine: Machine_dropdown_2.SelectedText,
          Reason: Reason_dropdown_1.SelectedText
         }
   ),
   Patch(
         Downtime,
         LookUp(Downtime, Operator.Value = Operator_dropdown_2.SelectedText.Value && Machine.Value = Machine_dropdown_2.SelectedText.Value && Reason.Value= Reason_dropdown_1.SelectedText),
         {
          Finish: Now()
         }
   )
)

Add !IsBlank(Finish) to verify is there a registry with same operator, machine and reason not finished yet. If there is, update the record, if not, created a new record.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution  to help the other members find it.

[Anonymous]

Hi @v-jefferni ,

I tried the new formula, but get this issue.

when patched 1st time it is registering the operator name, machine, downtime reason & start time. when patched 2nd time it again creating a new registry instead update the finish of 1st registry.

to answer your question, yes, same operator working in same machine  can also register same downtime reasons multiple time, and the formula should able to find & update the finish time of the last registerd combination of name, machine,reason if same. example they take breake 3 times, clean the floor 4 times a day. 

thats why i was thinking the one of the unique value here is the ID number, is it possible to lookup & update the finish time based on the ID number?? or please suggest me of possible solution to reach this result.

Thanks in advance!