ButtonType

Follow

Comments

17 comments

  • Avatar
    Brandon Carraway

    Article does not clearly state how the 'EDIT FILE' text gets inserted into the sheet.

    1
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello Brandon Carraway,

    Actually, it means the buttonType display the "EDIT FILE" text and it is linked to the link in the D column. As you can see we used buttonType(D,#ffc107), so it means we reference the D column as the link column.

    Kind regards.

    Thomas

    0
    Comment actions Permalink
  • Avatar
    Brandon Carraway

    Thomas,

     

    Thank you for the clarification, this definitely saved me a lot of headache because I was also having a problem with this... However, how do the words "Edit File" get entered into the spreadsheet?

    I see the code in the 'Template' tab, but it isn't translating over into my Awesome Table. 🤦‍♂️

    0
    Comment actions Permalink
  • Avatar
    Thomas Morin

    Hello Brandon, 

    I created a ticket, it will be easier to discuss with you.

    Kind regards.

    Thomas

    1
    Comment actions Permalink
  • Avatar
    Elizabeth Burden

    I also have the same question as Brandon. How does the button text get entered in the spreadsheet upon the trigger from the form?

     

    1
    Comment actions Permalink
  • Avatar
    Awesome Table

    Hello Elizabeth,

     

    Maybe this article could help you?

    https://support.awesome-table.com/hc/en-us/community/posts/360002591519-Create-an-Update-Button-when-using-a-Google-Form

    Please let me know if it helped.

    Nicolas

    0
    Comment actions Permalink
  • Avatar
    Brandon Carraway (Edited )

    Elizabeth, it's all in the 'Template' tab (if you don't have one, then make sure to create one).

    In this tab, you make a column header equal to the header in your data. (Photo below).

    The code in the example is a little bit out of alignment with the tutorials, however, in your case, it the code should look like this: 

    <div class"button-container"> <a class="button" href="{{Job #}}" target="_blank">EDIT FILE</a> </div>

    I hope this helps you, as most of the guides are not very clear. Please let me know if you are still having issues.

    -Brandon

     

    0
    Comment actions Permalink
  • Avatar
    François Jourde

    Hello, I don't know why I'm getting these errors messages...

    Any idea? Thanks in advance.

    Spreadsheet: 

    https://docs.google.com/spreadsheets/d/1ngPfFD8_YpA1TuR5lXx93FxLqUVhWRVi1BofFkyjcT0/edit?usp=sharing

    Visualisation:

    https://sites.google.com/view/jourde/activit%C3%A9s

     

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo (Edited )

    Hi @François.

    If you rename one of the duplicate headers appropriately, this should be fixed (see screenshot below).

    Just remember that you also need to use the same header / label if you used that same column (marker) on your HTML & CSS templates (e.g., replace LIEN [column H] with LIEN2 on your CSS template).

    Hope this helps.

    - Randy

     

    0
    Comment actions Permalink
  • Avatar
    François Jourde

    Dear Randy: it worked like a charm.

    Thanks a lot.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Glad to be of service, François :) 

    0
    Comment actions Permalink
  • Avatar
    Creston Communications

    Rather than a drop down as a sort criteria is there a way to have button instead with a pre-selected choice? For example "House" is either a yes or no. I want folks to be able to select House and it automatically selects those with a house (the yes's). Same for Full Time. This would make things a lot easier for our end users.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi @Creston Communications.

    Please create a Feature Request with the specifications you mentioned.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Erp

    Hello, 

    Is it possible to make a ButtonType open 2 links at the same time?

    Thx

    1
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi @Erp.

    This is not possible with our buttonType keyword.

    - Randy

    0
    Comment actions Permalink
  • Avatar
    Jefry Mendoza

    Hola buenos días!

    He estado intentando hacer uso del buttonType pero no me funciona, no se si estoy ingresando algo equivocadamente. Me podrían ayudar por favor.

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi @Jefry.

    1) Please try putting a header on cell C1 (for example: Click here). 
    Then refresh or reload your view by pressing F5 on your keyboard.

    2) Also, check that column C is included in your data-range. More about it here.

    If these don't help, 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 contain confidential info.

    - Randy

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.