AppSheet Batch Update | Use an Input pop-up to assign values to muliple records
ฝัง
- เผยแพร่เมื่อ 8 มิ.ย. 2024
- Learn how to set-up a pop-up box in AppSheet to allow users to assign a value to a column of multiple records at the same time.
Editing records in AppSheet may take a lot of clicks for your users just to edit a single field. But there will be times that your users would need to edit several records with the same information, and it would be great to give them an option to do this as a batch, saving time and avoiding frustrations.
This video utilizes the new [_INPUT] function of AppSheet, which triggers an Input popup box to allow users to enter new values for one or more columns of multiple records selected.
Building from this app, watch this next:
• How to Control AppShee...
_______________________________________
Recommended Related Video:
5 Ways to Create Dropdowns in AppSheet
• Top 5 Ways to Make Dro...
===========================
Video Chapters:
00:00 What is a Batch Update
00:12 A little bit about this Channel
00:45 The challenge in editing records 1 by 1
01:39 Set up an action to edit column values for a single row
02:51 Planning what we want to accomplish
03:56 Set up the Input box for our action
05:13 Using the [_INPUT] expression
06:04 Testing our Input Box
07:36 What are the possibilities?
===========================
#appsheet #tutorial #howto
#input #inputpopup #popupbox
#batchupdate #batchedit #editmultiplerecords
#buildingwithappsheet - แนวปฏิบัติและการใช้ชีวิต
Thank you !! Very Happy to be a subscriber - Really Like your style of teaching !
Thanks for the sub! I am happy that my teaching style resonates with your learning style. 🤗
Fantastic!!!
Many thanks!
This is amazing !!!! Wow 😂thanks a lot
Indeed. AppSheet is truly amazing! 😅
Very good explanation. Thanks for sharing.👍👍
Glad it was helpful!
Great video. It is possible to use a pop up input in the "add a new row to another table using values of this row" action.
I need to duplicate a set of rows and change the value of one column for all the rows. This value need to be define with a popup input
Unfortunately not. I've requested this feature many years ago. But as of today, INPUT() still doesn't work with that action. The row gets added without the popup ever showing up.
The only available alternative is the LINKTOFORM() function, which is not a popup, but can give you controls as to what will be the data entered in each field based on the current record.
Thanks!
Welcome! I hope you subbed. 😊
I will use this new hability to create a project tasks and milestones assigned to different people on my team
Great catch.
That's also what we mostly use it for.
As well as updating the status of several tasks or projects as a batch.
thanks
Welcome
I am planning to create a inventory count app using with appsheet.for each month. How can i store each month data after my monthly stock count
Simply have a #Montly Count# table with the information you need to be recorded.
Think of it this way, if pretending that everything works on paper, how would your monthly count form print out look like? What are the information you will wirte on the paper?
Perhaps you wll have the following, right?
[Month]
[Date of Count]
[Counted By]
INVENTORY ITEMS
[Item Name]
[Qty]
Once you have this figured out, then simlply implement the same in your app.
In the example above, you may need three tables.
#Monthly Count#
#Related Monthly Inventory Items#
#Inventory Items#
You may refer to my video about Many-to-Many relationships as a guide in setting up the table relationships.
It worked well for me, the only problem is when I hit save the main view of the application opens. I want it to stay in the same view where I edit the data. Can you help me please?
What did you mean by that? What was the current view before you clicked the button to trooger the pop-up?
@@FullOfSheets For example, I am in view "X", I make the Input for view "X", but when I press "save" after saving the value in the "Input", view "Y" opens
I don't experience it so it must be something else in your app, specifically.
Check first the Finish View of the original form of "x". That may be teiggering to change the view after editing.
Take note that making the change through Input() is like opening the form, making tue edit, and then saving it.
youtube.com/@FullOfSheets I am happy to be a subscriber. Could you please make a dedicated video on (_INPUT) function? I am unable to get dropdown at input popup. Thanks for every fruitful video
Thank you, I appreciate it.
I have demonstrated the INPUT() function in this video. It's exactly the same. The dropdown will automatically show in the Input popup, if that column is already configured as a dropdown even if not in Input. You cannot just create the dropdown in the input popup. It must be a dropdown everywhere.
Also, the main ossue here is that AppSheet does not respect whatever you put as the Default Vakue in the Input setting. It does this before which is why I suggested to put "".
But for some reason, it now disregards it and just uses the value of the first row selected as the default value.
it works only when I change the value of the input. for example, the value in the first row is "A" and the one in the second one is "B" so when I select the rows and push the action button, the default value is "A" so I click Save without changing anything to make the values in each rows "A". nothing happens but if I change the value from "A" to "B" and "B" to "A", it will make alll "A". how can I fix this?
Did you try to put "" in the default value of the Input?
This way, it forces the user to make a selection since the field in the popup is blank.
@@FullOfSheets Thanks so much for your reaply. I tried but still the value comes from the first row. but I want the value in the input to be coming from the first row.
Let me explain again. My understanding about the INPUT function is as per below.
1. Presse the action buton and the popup appears after sellecting rows with the appsheet built-in multi-selection function. The default value in the input comes from the first row.
2. Change the value in the input on the popup and it will change the value in each row only on the frontend***.
3. If you press the save button, the changes will be written onto the actual DB(googlesheet,etc) if you press the cancel button, the frontend will be back to what the DB says.
the issue comes from the number 2. if you don't change the value in the input and just presse save, anything won't happen even if the value in the second row is not the same as the value in the input.
if there is only one input, I still can use the batch update by changing the value from one to another and back to what it was but I am faced with the worse issue if there are multiple inputs. those inputs work independently so the values on the frontend change only based on the releated inputs. so I have to change the values in all the inputs from one to another and back to what they originally were even if there are some inputs that I don't want to change and colums in some rows are different form the first row.
sorry for my bad explanantion and I hope you understand.
so the possible solution would be the one to match all the values based on the first row on the frontend as soon as you presse the action button and the popup appears. I think , in that way, all the changes will be detected and written into DB.
@stevekim1524 I understood what you meant. But I'm not sure you understand what the Input is supposed to do.
The Input function does a batch change to all your selected rows.
This means that whatever you choose in the Input pop up fields will apply to all the rows you selected. It is like going to the Google Sheet and copy pasting the values to the columns if all the rows you want - and it will all be the same values, otherwise you will have to do multiple copy-pastes separately.
If you have multiple fields in your Input popup, then it will change all the values of all those fields/columns for all the rows you selected. Otherwise, you will have to do multiple separate inputs, as how you do multiple copy-pastes in the sheet.
You can not use it to apply the changes only on some of the rows you selected, or only on some of the columns.
@@FullOfSheets I don't think I explained enough to make you understand what I meant. Of course, I want to make the value in the column in all the selected rows the same. why would I use the batch update if I didn't? simply put, let's say you selected two rows. the value in the first row is "A", and the value in the second one is "B". when you push the action button for input, the default value is "A" and I would like to make the values in both rows "A", meaning you don't have to change the value of the input, right? and all I think you have to do is you press save button thinking that the value in both rows will be changed to "A". But the value in the second won't be changed to "A" because you didn't change the value of the input at all(changing the value of the input is a trigger). you just used the initial value. I assuem if you don't change the value of the input, Appsheet won't change the value in the second row. Technically, Appsheet won't do anything if you just click save button with the initial value.
Excelent
Thanks.