Hi @MostafaGamal ,
Do you want to update all rows related to the current sign in user?
Do you want to update single one record when you press the button each time?
Based on the formula that you mentioned, I think there is something wrong with it. The First(Filter(UsersBOS, MailOfUser = User().Email)) formula could only filter the first record whose MailOfUser column is current sign in user. This formula would not detect if the 'No.OfEntreis' column has value in it.
On your side, please consider modify your formula as below:
Patch(
UsersBOS,
First(
Filter(
UsersBOS,
MailOfUser = User().Email,
IsBlank('No.OfEntreis') // Add formula here
)
),
{
'No.OfEntreis': 1,
EntriesTime: Now()
}
)
Please take a try with above formula, hopes it could solve your problem.
In addition, if you want to update all related rows for current sign in user when you press the Button once time, please try the the following UpdateIf formula:
UpdateIf(
UsersBOS,
MailOfUser = User().Email,
{
'No.OfEntreis': 1,
EntriesTime: Now()
}
)
Best regards,
