Record When User/visitor click button using Patch

[fikyf]

Hi,

Hoping someone can help because I just cannot work this out. I created icon in Gallery to launch attachment and when the user/visitor click the icon, it will bring to new tab of attachment and record the status.

Launch attachment is success but the record status is not work.

This is my Gallery :

Patch(FormContract.Updates,FormContract.LastSubmit,{SubmitStatus:"Completed"});Launch(First(ThisItem.Attachments).AbsoluteUri)

then I want to call the patch record in other screen

Please inform me if there is any wrong formula

[Ramole]

@fikyf 

Are you patching a form to where ? I don't see DataSource like 

New Record

Patch( DataSource, Defaults( DataSource ), { SubmitStatus:"Completed" },FormContract.Updates );Launch(First(ThisItem.Attachments).AbsoluteUri)

Is the SubmitStatus a choice field ?

If yes change to SubmitStatus: {Value: "Completed"}

[fikyf]

Hi @Ramole ,

Thanks for your respond. After change the formula, I success to update the record :

Patch('DDF List Upload',Gallery1.Selected,{'Log History':"Read"})

But its only record one data, I need to record multiple data in that column and also with the date and person who click the button.

Do you have any idea how to record multiple data to sharepoint list and also include the date and the person/viewer.

So what I want the 'Log History' will capture this :

Read on 8, Aug 2021 by {person in our organization}

Read on 10 Aug, 2021 {person in our organization}

[Ramole]

Hi @fikyf 

see below the instruction 

[Ramole]

Hi @fikyf 

        
        Patch(
            'DDF List Upload',
             Gallery1.Selected,
            
            {
                  'Log History':"Read",
                  Title: User().FullName,
                  DateEdited: Now(),
                  DocumentViewedID:Gallery1.Selected.ID

}

)

As I cannot see you list screenshot, just add create a field name DateEdited as Single line of text  and DocumentViewedID as Single line of text , that way you will know which document is viewed also

[Ramole · Accepted solution]

@fikyf 

Do you want Append Text and Add some time stamps and user info? watch this video 

Append Text - Using forms or Patch create update only fields 

[fikyf]

hi @Ramole ,

Thank you so much, this is exactly what I mean, you're very helpful

I watched your video reference and make some modification,

Set(
varRecord,
ThisItem
);
Patch(
'DDF List Upload',
varRecord,
{'Log History': varRecord.'Log History' & "Read " & User().FullName & " " & Now() & " " & Char(13)}
);
Launch(First(ThisItem.Attachments).AbsoluteUri)

now, if user click the icon in the gallery, he will launch attachment and it also record their activity in log history (by time stamp)

Thank you @Ramole 

Regards,