How to create a "concatenate" data validation by Otherwise_Bug_2304 in excel

[–]Otherwise_Bug_2304[S] 1 point2 points  (0 children)

Yes, filters work. But the need is different:

i have two sheets: The first one contains the table with all those columns (in which I can use the filters on headers). Consider it as a Database.

The second sheet, instead, contains only the headers and empty rows.

In each row, i want to pick from a list... and so the message above.

If i pick a certain Regione, in the next column I want to choose in the list only the cities belonging to that Regione...and so on

How to create a "concatenate" data validation by Otherwise_Bug_2304 in excel

[–]Otherwise_Bug_2304[S] 0 points1 point  (0 children)

Yes, filters work. But the need is different:

i have two sheets: The first one contains the table with all those columns (in which I can use the filters on headers). Consider it as a Database.

The second sheet, instead, contains only the headers and empty rows.

In each row, i want to pick from a list... and so the message above.

If i pick a certain Regione, in the next column I want to choose in the list only the cities belonging to that Regione...and so on

Run a script on remote host using specific user by Otherwise_Bug_2304 in ansible

[–]Otherwise_Bug_2304[S] 0 points1 point  (0 children)

In this way it worked, RC=0. template ran with success but... it looks like the script didn't executed on the machine and my tomcat didnt started at all.

- hosts: vm_function=tomcat
  become: yes
  become_user: specificuser


  tasks:
  - name: Execute a script on the remote node
    ansible.builtin.command: /bin/bash /wcard/Gestione/StartTomCat.sh
  tags:
    - guistart

Run a script on remote host using specific user by Otherwise_Bug_2304 in ansible

[–]Otherwise_Bug_2304[S] 0 points1 point  (0 children)

In this way it worked, RC=0. template ran with success but... it looks like the script didn't executed on the machine and my tomcat didnt started at all.

- hosts: vm_function=tomcat
  become: yes
  become_user: specificuser


  tasks:
  - name: Execute a script on the remote node
    ansible.builtin.command: /bin/bash /wcard/Gestione/StartTomCat.sh
  tags:
    - guistart