Updating one column if the other column matches (Reset a password)

[SecretAdmirer09]

Hi Everyone,

I would like to seek help please if it's possible to update just one column (database) if the other column matches what's on the database.

This will serve as my reset a password or forgot password. I'm thinking if i should use Patch or UpdateIf.

If so, can anyone help me with the formula?

We can call the database as Database1, Name as Name, Age as Age and Password as Pass.

Hope this one is clear, Thank you!

[mmbr1606]

hey @SecretAdmirer09 

try this please:

Patch(
    Database1, 
    LookUp(Database1, Name = "SpecificUserName"),
    {Pass: "NewPassword"}
)

Remember to replace "SpecificUserName" and "NewPassword" with the appropriate values or variables from your application.

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[Ethan_R]

Hi @SecretAdmirer09 ,

Can you elaborate your table and use-case?

UpdateIf can update several records if condition is matched, good for Bulk-Edit or say password reset.

If you need to update 1 record only, then Patch is suitable.

What is the datatype of your 1 column?

[SecretAdmirer09]

Apologies for the confusion. Let me give my table:

Database name is Ticketing Tool, under this database are:

Username, Password, When Question, Where Question, Member First Name, Member Last Name, Member ID

What i want to do is if the member forgot his/her password, he/she can click the forgot password button then will direct to this page where they will need to fill out this data; Username, when question, where question, member ID and New Password. Only if Username, when question, where question and member ID matches what is in the database, then that's the only time that the new password will change or update. 

[mmbr1606]

another try for ur explanatuon:

If(
    CountRows(
        LookUp(
            'Ticketing Tool', 
            Username = txtUsername.Text && 
            'When Question' = txtWhenQuestion.Text && 
            'Where Question' = txtWhereQuestion.Text && 
            'Member ID' = txtMemberID.Text
        )
    ) > 0,
    Patch(
        'Ticketing Tool', 
        LookUp(
            'Ticketing Tool', 
            Username = txtUsername.Text && 
            'When Question' = txtWhenQuestion.Text && 
            'Where Question' = txtWhereQuestion.Text && 
            'Member ID' = txtMemberID.Text
        ), 
        {Password: txtNewPassword.Text}
    )
)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.



Greetings

[SecretAdmirer09]

The last part is not working, only showing error.

{Password: txtNewPassword.Text}

If(
CountRows(
LookUp(
'eProc Ticketing Tool (Access List)',
Username= 'Fill 1'.Text&&
Password='Fill 2'.Text&&
'When Question'='Fill 3'.Text&&
'Where Question' = 'Fill 4'.Text &&
'Member ID' = 'Fill 5'.Text)
) > 0,
Patch(
'eProc Ticketing Tool (Access List)',
Username= 'Fill 1'.Text&&
'When Question'='Fill 3'.Text&&
'Where Question' = 'Fill 4'.Text &&
'Member ID' = 'Fill 5'.Text
),

[mmbr1606]

which error do u get?

[SecretAdmirer09]

{Password: txtNewPassword.Text}

This part, it is not working. it's all red. Tried doing this  {'Password'='fill 2'.Text} but still doesn't work.

[mmbr1606]

on the top right there is a stetoscope, there u should see an error. can u please tell us what it says?

[SecretAdmirer09]

Here's what it says