Dear team, Is it possible to have an action ...

(Etwo Cargo) #1

Dear team,

Is it possible to have an action button to clear all column? Example; There is some information in column A [row 12,13,14,18,28,48]. Any possibility to clear those rows after pres only that button by using action option?

(Suvrutt Gurjar) #2

Hi @Etwo_Cargo ,Are you looking to execute a user action

in a single column but in different multiple rows? Could you please add what type of column it is?

(Etwo Cargo) #3

Hi, It is text column only. That is right identify. Press that button and clear all information which are in single column but different rows. Thanks for support in advance.

(Suvrutt Gurjar) #4

Hi @Etwo_Cargo,Please consider using a data

action “Set the value of a column” on that column. Please set the action Change value to " "

Now please use this action in bulk action mode in table summary mode to select the rows where you wish to have this column value to be blank.

Relevant Sample app link is below.

appsheet.com - Bulk actions - One way to apply an action to multiple rows Bulk actions - One way to apply an action to multiple rows appsheet.com

(Etwo Cargo) #5

Hi@Suvrutt_Gurjar

Sorry to say but this is not best solution actually. What if i have 200 rows and 78 of them are not empty and think that i wanna to clear them with one button. User should able to to this. This is Russian way :slight_smile: which you mentioned. With that way users must press 78 times.

And please think that the filled rows are not sequential like 1,2,3,4,5,6,7,8,9,10. They are 1,18,68,54,61,59,8,25 like so…

(GP Kriel) #6

@Etwo_Cargo have a look at this appsheet webinar, Santiago explains some concepts that may work for you in this case. youtube.com - Automate Tasks & App Launchers | Office Hours | Appsheet Automate Tasks & App Launchers | Office Hours | Appsheet