Greeting everyone
i'm new here
and here i have this form (source come from excel table)
anyway i want change status value of this form by code
for example when user pressd approve i want change (modify) status value by code to approve
Solved! Go to Solution.
Hi @mqi,
Do you want to modified Status value of a record from your datasource?
What is the Item property of your DetailForm? Formula like "BrowseGallery1.Selected"? Are you opening this screen from your gallery screen?
If yes, you can try this formula in your Approve button(I have tested this formula when Status column is a dropdown field or a Text field in my Excel, but pay attention, if this is a dropdown field, make sure "Approve" is one of the selections of your dropdown):
Patch(TableName,BrowseGallery1.Selected,{Status:"Approve"})
Best regard,
Allen
Hi @mqi,
Do you want to modified Status value of a record from your datasource?
What is the Item property of your DetailForm? Formula like "BrowseGallery1.Selected"? Are you opening this screen from your gallery screen?
If yes, you can try this formula in your Approve button(I have tested this formula when Status column is a dropdown field or a Text field in my Excel, but pay attention, if this is a dropdown field, make sure "Approve" is one of the selections of your dropdown):
Patch(TableName,BrowseGallery1.Selected,{Status:"Approve"})
Best regard,
Allen