Patch Formula

[J_Easter]

Good afternoon! I just can't seem to get past the Patch formula. I have scrapped my form and restarted it many times because nothing seems to work for me. I have attached a photo of my latest form and patch formula, plus the error detail. Any help to finally get past this step would be greatly appreciated! Thank you!

[BCBuizer]

Hi @J_Easter ,

From the screenshot of the form it seems the Name data card contains a Text Input control:

However, in the record argument of the Patch function you are referring to DataCardValue3.Selected for the Name field:

Since a Text Input control does not have a Selected property, an error is returned. Instead try to use the Text property:

{
    Name: DataCardValue3.Text,
    ....

[J_Easter]

@BCBuizer thank you for the suggestion. I have updated the formula and am still getting an error of some sort. It creates a new record instead of updating the current record and it does not return me to the home screen. I appreciate your help. Thank you!

[BCBuizer]

Hi @J_Easter ,

I see two syntax errors in your formula: a missing closing bracket for the LookUp function and the use of a comma where you should use a semicolon:

Please try with the corrected formula and see if you still have any of the other symptoms.

[J_Easter]

@BCBuizer Thank you! I finally don't receive any errors 😁 but unfortunately, it is still not performing as expected. It still creates a new record as opposed to patching the record which should be identified through the lookup of the microchip id if I'm not mistaken. Also, in the new record it creates, the Claimed for Foster status is not populating.

[BCBuizer]

Hi @J_Easter ,

If a new items is created, I suspect the LookUp function is not working as intended, probably because the value entered in DataCardValue2 is not an existing Microchip ID.

In case you are using some screen where the user comes to select an animal from a gallery before they come to the screen with the form, it is much better to use the selected item from the gallery instead of relying on the user to type an ID:

LookUp(
    'Animal Tables',
    MicrochipID = Gallery.Selected.MicrochipID
)

When you have this working, you can simply remove the MicrochipID datacard from the form.

[J_Easter]

@BCBuizer Yes, there is a gallery where they select on an animal before they get to the form. I attempted to enter your suggestion, but now the formula has an error again and it still did not update the record. Thank you for taking the time to help me better understand.

[Corry]

Hi @J_Easter,

To ensure your form is populated with the information from the gallery item you select, you need to set the 'Items' property of your form to galfoster.Selected.  This will ensure that the information from the gallery appears in the columns (fields) you have added to the form.

How you update a record in your table will depend on how your form is constructed. If your form contains all the columns that you wish to update, whether these be text input or combobox's, you can simply use the SubmitForm(galfoster) formula.

Test Scenario

I performed a basic test with a gallery and a form using a combination of ComboBox's and Text Inputs for an existing record. I added the columns to a table and then added them to my gallery and form. I used the 'SubmitForm(Form Name) approach only, and all details that were entered were updated as shown in the below image.

Because we are connected directly to the data source, and all fields we wanted to update are present in the form, we don't need to use the Patch method.

I hope this information was helpful in troubleshooting your approach.

[BCBuizer]

Hi @J_Easter ,

You were nearly there, just a comma is missing: