Using Automation to (Mass Update Values) from One Table to Another | AppSheet Explained

[@jaredmazzis9930]

I waited for 532 rows to update this morning. Now I don't have to do that anymore. Thanks Matt

[@MultitechVisions]

It's a nice little hack-of-a-way to get your updates done "now" without having all that wait time. Cheers mate!

[@dzeips]

Another video that is good only for people who actually know all of this before watching. As a beginner who tries to learn appsheet all in this video makes no sense.

[@sb_raash]

Thanks dude. Btw nice hat😉

[@tambordino]

Hi Joe, a very interesting video! I tried to follow all the steps but it doesn't work because I have 2 tables: Leads and Status
The key that connects them is the email. I want to update the Status column of the Leads table every time an update of an already existing lead is added to the Status table. How can I do? Thanks in advance for your reply!

[@ukaa]

Cool 👍👍

[@mansisingh630]

Hi, I actually am trying to add a selectAll action to my sliced data but it doesn't work. And second thing is that I want to update a column of my sliced data on selectAll action, by choosing an enum value from dropdown which is another datasheet(I suppose another action).
Please can you guide me with these two issues.
Thanks.

[@iikingvegasii]

I have static Columns in my spreadsheet (Dr Notes and Phone number) that are put in by the users of the app and autofill the Notes and Phone columns in the main spreadsheet with the info the user puts in, but when i add new people to my main spreadsheet, the updates push cells down and the static Phone and Notes are out of order. Something like your video seems like what i need to do, but I almost have to do it in reverse. Cant quite figure it out. Im guessing I need a separate tab in the Spreadsheet that houses the notes and phone numbers, Uses a Key to match up with the right person and then backfills the main spreadsheet.
Does this sound right. Any idea of a good tutorial pointing me in the right direction. Yours is close but not exact. Thanks, im obvy new at this.

[@zocounlimited3136]

Hey Matt, Is there any way for this to process through errors? It gets stuck on cells that violate a valid if statement. ie: Row has an inactive employee where the validation states Active Employee list, employee is no longer active, it won't run any of it..

[@MultitechVisions]

Unfortunately no. The Automation error side of things is... tricky, and tedious at times.
- Best way I've found, which works like 99.9% of the time, is to throw in some IF() statement into the mix.
IF(Context("host") = "Server",
Employees[EmployeeID],
Active_Employees[EmployeeID]
)
Something like that, so that when it runs on the server it's accessing everything instead of the limited set.
- You might consider doing this anyways, as eventually every value in that field will likely become invalid at some point. (As every employee could potentially no longer be an employee).
- I generally stick to the idea of: "The first time they're creating the record, enforce the validation"; or "Enforce the validation based on a [Status] column"
Cheers!

[@ariefugi2000]

this caption should be "update another table when crud"

[@AdvancementAxis]

Hi
can i call up information in two different columns using a single text field

[@MultitechVisions]

Yup! Concatenate() is the formula you'd want to use for this.
- This is actually a very common thing I'll do
- I'll create a Show(Text) column, with a giant Concatenate() formula, combining a bunch of stuff together into a "summary display" or sorts.

[@pabloeliassilva5263]

Creo que para las cuentas gratuitas este sistema sólo permite la actualización de 1000 filas, pero más que suficiente para muchos casos

[@MultitechVisions]

It's actually based on the deployment status of the app. th-cam.com/video/oDHT_0nlj7U/w-d-xo.html