Patch formula

[mgreen91]

Hi,

Can someone help with what error i have in this patch formula?

Patch('Animal Information', {'Animal Information':'Foster Animal Form'.LastSubmit};

Refresh('Animal Information'); Navigate('Home Screen'); Notify( "Thank you for fostering a rescue animal!", NotificationType.Success)

[mgreen91]

Hi

Thank you for the formula

I have tried it both ways:

Form On Success

Patch(

    'Animal Information',

    LookUp(

        'Animal Information',

        'Animal Information' = Form1.LastSubmit.'Animal Information'

    ),

    {

        'Shelter Status': 'Shelter Status (Animal Information)'.'Claimed for Foster'

    }

)

Submit button - 

SubmitForm(Form1);

Navigate('Home Screen');

Notify("Thank you for applying to foster an animal!", NotificationType.Success)

This works on the form however doesn't update the record on the table, it still says ready to foster instead of claimed for foster.

I also tried it where i just have the shelter status as part of the form for the user to change this to claimed for foster and then the submit button, this also doesn't update the record.

[Corry]

Hi @J_Easter,

Go to your table in the solution window and select your columns, you will see a column with the data type unique identifier. It is usually the same name as your table but plural. So for me, my table is called Animal and the unique identifier is animals.

[J_Easter]

@Corry Thank you for that explanation. Unfortunately, I am still stuck.  I tried to follow the example you shared but with no luck.

Patch(

    Animal Table,

    LookUp(

        Animal Table,

        pu_animaltableid = Form1.LastSubmit.Animal Table

    ),

    {

        'Shelter Status': 'Shelter Status (Animal Table)'.'Claimed for Foster'

    }

);

Notify(

    "Form successfully submitted",

    NotificationType.Success

)

[mgreen91]

Hi

I have got the Submit form option to work on one of my forms, but it is not working for the Foster an Animal form. The only fields I have are Animal Name, Foster Claimer and Shelter Status. Do I have to have any other column for it to work?

[Corry]

HI @J_Easter,

I updated my table name to match your table name as this may better highlight the differences.

Here is the formula I have entered that produces no syntax errors.

Patch(
    'Animal Tables',
    LookUp(
        'Animal Tables',
        cr0f4_animalsid = Form2_1.LastSubmit.Animals
    ),
    {'Shelter Status': 'Shelter Status (Animal Tables)'.'Claimed for Foster'}
)

I have highlighted in red the part of your formula that needs correction. the value after LastSubmit. should be the column name (Display Name) of your unique identifier column. This is your 'Logical Name' of that column "pu_animaltableid".

Please also note that the patch formula is being used in the OnSuccess property of the form as the Shelter Status column is not in the form itself.

If the shelter status column is still in the form within your canvas app. This formula may not work as intended.

[mgreen91]

I have used this too and it is not updating the record still:

Patch(

    'Animal Information',

    LookUp(

        'Animal Information',

        'Animal ID' = 'Foster an Animal Form'.LastSubmit.'Animal ID'

    ),

    {

        'Shelter Status': 'Shelter Status (Animal Information)'.'Claimed for Foster'

    }

)

[mgreen91]

I have used the Submit button instead and kept the Shelter Status as a drop down on the form - Thank you @Corry  and @ZeeScience  for all your help!!!

[Corry]

HI @mgreen91,

It is really important that you are using the 'Logical Name' of your 'Unique Identifier' column and the display name of the 'Unique Identifier' column.

Here is where those 2 parts need to be in the formula I am using.

Unique Identifier Column

Logical Name

Display Name

Patch(
    'Animal Information',
    LookUp(
        'Animal Information',
        'Animal ID' = 'Foster an Animal Form'.LastSubmit.'Animal ID'
    ),
    {
        'Shelter Status': 'Shelter Status (Animal Information)'.'Claimed for Foster'
    }
)

This is what my Unique Identifier Column looks like.

To get the Logical Name, click the 3 vertical dots as shown in the below image.