Updating a separate table when a form is submitted. Error in app.

I have two tables that need to interact.

1 is "Mileage Tracking" and the 2nd is "Inspections"

When the user fills out the inspection form, the column [Vehicle] is automatically set to that users truck VIN. The user enters a value for miles in [Odometer reading] and the date is auto saved in [Date/Time] among other unrelated info. I need the new [Odometer reading] data entered into the [Last Inspection Miles] column of "Mileage Tracking" an d the [Date/Time] data moved into [Last Inspection Date].

The "Mileage Tracking table shares a key with Inspections. The Key is [Vehicle] in "Inspections" and [VIN] in "Mileage Tracking"

I Created an action in "Inspections" Called Action A. The photo shows it's settings.

Screenshot 2024-08-30 134906.pngScreenshot 2024-08-30 134928.png

I Created an action in "Mileage Tracking" called Action B. See Below.

Screenshot 2024-08-30 135119.png

When I submit a new inspection form I get the following error.

Screenshot_20240830_135300_AppSheet.jpg

I followed old videos on YouTube to get this far. I am great at programming PLCs but this is a new world. I hope someone can point me in the right direction to get this working. I have automations that depend on the data in the Mileage Tracking so that we can schedule service for the guys in a more efficient manor. Were a small shop with about 20 employees total.

Thank you for your time.

Solved Solved
0 8 281
1 ACCEPTED SOLUTION

Okay I was able to rub a few brain cells together to finish this task.

First of all I would like to thank @Steve For giving me the foundation to lean on with this endeavor.

Following the screenshots below you can set this up in just a few minuets. It is important that the ref columns on both tables contain the same identifying information.

In the Actions tab add a new action for the table that you want to affect. Next to the table name you will see a + icon if you hover your mouse. Skip the AI junk and select Create new action for (table). Follow the structure in the first screenshot.

PyramidRebuild_0-1725630500138.png

 

You may see some warnings that will go away after saving your app.

Now add an action to the table that will be providing the data to update the affected table. Follow the second screenshot.

PyramidRebuild_1-1725630500303.png

 

Save your app.

Once a user completes a form to add a row to the source table it will cause the data to be updated automatically to the affected table.

View solution in original post

8 REPLIES 8
Top Labels in this Space