Set up one search bar for several columns

Comments

6 comments

  • Buenas tardes, tengo una necesidad al momento de visualizar los datos, quiero que al iniciar la navegación en la herramienta, no me aparezca la tabla o la base de datos completa como tal, si no que halla un formulario para ingresar los nombres de las columnas de las que desasee ver los datos y a partir de esas columnas crear filtros por parámetros, es decir que el mismo usuario moldee la base de datos para visualizar datos específicos 

    0
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello,

    We are sorry but we don't understand your problem.

    Could you create a ticket and give us details in English?

    Thanks in advance.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Viacheslav Yurchenkov

    On step 2 when I add search in the template list for no reason it kills my <style> in preview. What makes it work wrong?

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi @Viacheslav.

    Please share your:

    AwesomeTable link - Share with us your AwesomeTable & Google Sheets datasource so we can pinpoint where the problem is and provide the right solution at the soonest possible time. Detailed instructions here.

    Google Sheets datasource - It's best to set the sharing settings to Anyone with the link. Click here to learn more.

    * You can opt to anonymize your content by using dummy data (fake, but realistic) if your Sheets contains confidential info.

    * Or add me as a collaborator by granting me view-only access.


    - Randy

    0
    Comment actions Permalink
  • Avatar
    Viacheslav Yurchenkov

    Hi Randolph Abelardo!

    I shared a link with you from technologies.cu google profile.

    You can find a link to awesome table in the template page.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Приве́т @Viacheslav.

    Thanks for sharing the files. We need to update the Templates Range if we add a new column (otherwise, the layout will get messed up - like what happened in your screenshot). Originally, the templates only had 3 columns ("Template!A1:C2"), but since we added the поиск column, the Templates Range should indicate "Template!A1:D2". You can learn more about it here. (Fig. 1 below)
    (Fig. 2 - Updated version)

    I also made the field the 1st filter to display. To undo this, simply delete the Query statement:

    select H,A,B,C,D,E,F,G

    * Don't forget to click the UPDATE VIEW button for the changes to take effect.

    But if you want to reorder the filters, click here to learn more.

    I sent the modified replica-view to your email with the correct settings. Simply click the USE TEMPLATE button (top-right corner) to create your own copy.

    Hope this helps.


    - Randy


    FIg. 1

     

    Fig. 2

    0
    Comment actions Permalink

Please sign in to leave a comment.