Auto Update Multiple Row One Clicked Icon

[Sirfyaad]

Hi, 

I want to be an update icon. So that I can easily update all our data at once. I want the behaviour icon to work here only if the [SKU] column is empty. Can you tell how can I make it. Help me in this. 

[WillowMobileSys]

An Action Button (or behavior icon as you call it) is just an action where you set the Icon that is displayed.  I think you know how to create that so I won't describe that here.  You'll need to decide where you want it to be seen by a user in order to set the Appearance->Prominence setting within that action.

Based on your description, you then want this action button to update multiple rows when it is tapped.  To do that you will want to set this action as a Grouped action.  Next create a set of other actions that perform your desired updates and then assign each of them to the Grouped Action Button in the order they need to be executed.

[Sirfyaad]

Thank you for replying. But I have never become a behavior icon. Please help it out.

[WillowMobileSys]

Please start with this help article below.  It covers all the basics of using actions including using them as Action Buttons within the app.

AppSheet Help - Actions: The Essentials

[Sirfyaad]

Kindly give me example. Please 

[WillowMobileSys]

Based on the few details, I can only help you get started.  I'll show the start of action you can use as a button but you will need to figure out what kind of action you will need based on what row updates you need to make OR provide those details so the rest of us can try to help.

To create an action button is easy.  Go to the Behavior tab, tap the new action button at the top, name your action and select source table which establishes for which views the action will show and which table rows the action operates on. 

Start of an action button that appears only if SKU is blank

Set where/how the action appears in Views

[Sirfyaad]

Which Expression i put in this.

ERROR

[WillowMobileSys]

We need to know what rows you are trying to Update and in what way they need to be updated.

[Sirfyaad]

my sheet name is mpop campus scan sheet and i am try to update sku columns when sku ccolumn is blank. 

[WillowMobileSys]

Now, I know you have been using AppSheet for a while.  I think you know how to create this SELECT() expression.   Give it a try first and then we can chime in to help.

[Sirfyaad]

I have put the select expression in the SKU column. Now tell me the next process

[Hussein_Osseily]

Step 1 is to Create an Action to update the column you want
Choose not to display this action

Create a new Action "Execute an action on a set of rows"
in the referenced Row you can use this : 
FILTER("MPOP CAMPUS SCAN SHEET", ISBLANK(SKU))

Referenced Action: 
Choose the action you have created in Step 1

and display this action the way you want, in a column or overlay,...

[Sirfyaad]

@Hussein_Osseily  @WillowMobileSys 

Thank you for your response.  I created two action but not working. Please see below image.

FIRST ACTIONSECOND ACTION

[Hussein_Osseily]

in action 1 , the SELECT expression doesn’t seem to be correct, if you may write it complete in a comment , and what value u exactly want that action to do in that particular column “SKU”

[Sirfyaad]

@Hussein_Osseily 

SELECT(NYKAA[Item SKU Code],[_THISROW].[AWB NO] = [SCAN CODE], TRUE)

Note: This expression could impact performance.

The list of values of column 'Item SKU Code'
....from rows of table 'NYKAA'
....where this condition is true: ((The value of 'AWB NO' from the row referenced by 'GATE ENTRY NO') is equal to (The value of column 'SCAN CODE'))

[Hussein_Osseily]

Once you test the expression above, the output is what you want ? 

[Sirfyaad]

I want the SKU column to be updated with the highlits icon if it is blank sku.

[WillowMobileSys]

You didn't specify HOW it's not working!

But looking at your action, you are assigning the SKU column a LIST of values - SELECT() function ALWAYS returns a LIST - even if there is only 1 it will be a LIST of 1 value.

I assume that SKU is meant for just a single value?

To fix, wrap your expression with the ANY() function which will return the FIRST value from the list:

ANY(SELECT(NYKAA[Item SKU Code],[_THISROW].[AWB NO] = [SCAN CODE], TRUE))

[Sirfyaad]

Hi @WillowMobileSys 

I have set this action behavior to update only. But it has a little issue. I want the data to be updated only when you click on the run sync icon. 

It's possible. 

[Hussein_Osseily]

I got what you want, but am asking if after testing this expression is giving you the value you looking up

SELECT(NYKAA[Item SKU Code],[_THISROW].[AWB NO] = [SCAN CODE], TRUE)

Go to where you have the expression and press Test as below: 

[Sirfyaad]

@Hussein_Osseily 

Screenshot

[Sirfyaad]

Hi @Hussein_Osseily @WillowMobileSys 

Please help me for making this. 

[Hussein_Osseily]

I thought we have sent you the step by step guide to achieve that.
beside that, if still not clear and if if that would work for you, I can get under the hood of your app  and create that action for you.

[Sirfyaad]

i follow every step. but not working. i dont no why.