Select multiple fields except one / Seleccionar varios campos excepto uno

[daniel1017]

Such a good day,

Sorry, I'm new to the platform and I wonder if I can count on your support, my problem is this:

I have a book in Excel with a column that contains several lines of transportation (more than 100), I would like to know a method by which puada generate a button with the action filter and select all lines except one. I understand that can be performed by the method "string" but eventually they will agegar more lines and the only thing I want is for the other lines without which specific display, made it clear they do not want to delete records from this line.

I hope I have explained and await your response.

Thank you so much!

- - - -

Que tal buen día,

Disculpen, soy nuevo con la plataforma y quisiera saber si puedo contar con su apoyo, mi problema es el siguiente:

Tengo un libro en Excel con una columna que contiene varias lineas de transporte (mas de 100), quisiera saber un método por el cual puada generar un botón con la acción de filtrar y seleccionar todas las lineas excepto una. Entiendo que se puede realizar por el metodo "Cadena de Texto" pero con el tiempo se van agegar mas lineas y lo unico que quiero es que se muestren las demas lineas sin la que especifico, dejo en claro que no quiero eliminar los registros de esta linea.

Espero me haya explicado y espero su respuesta.

Muchas Gracias!

Note: Edited by moderator to include English translation as a courtesy

[Marcio_Campestrini]

Daniel,

A solution for you is to show your user to select to value he don't want to see, click with the right button at the list box and then select the option "Select excluded". After this he can create a bookmark with this filter.

Hope this help you.

[daniel1017]

Thanks a lot for the answer Marco, I thought that, but is there a way i could transform the bookmark into an action button?

Thanks for you help!

[Marcio_Campestrini]

Daniel

You can create a button (or a text object) and define an action: Action Type: Bookmark / Action: Apply Bookmark, and you put the ID of the bookmark that you created.

The BookmarkID you verify acessing Bookmarks/More, and look the bookmark you created.

[effinty2112]

Hi Daniel,

If each row can be identified by a field 'TransportationID' then if you select on that field first you can select all excluded using a button with the action shown below.

[daniel1017]

Thanks so much Andrew it works a lot for me your answer, great help!

[daniel1017]

Thanks Marco,

Now i know how to create that action buttons, thanks alot fo the help.

Have a nice day!

[Marcio_Campestrini]

Hi Daniel

Is your problem solved? If yes, please mark helpful/correct questions to close the thread.

Thanks.

[Marcio_Campestrini]

Hi

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

[Marcio_Campestrini]

Got you issue solved? Please mark helpful/correct answers.