ButtonType

Follow

Comments

15 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

Please sign in to leave a comment.