ButtonType

Follow

Comments

35 comments

  • Avatar
    Jeroen Baert

    Is there a way to set a color per button?

    For example, in row 1, I want a yellow & red, in row 2 a yellow & blue, row 3 a blue & red,... No logic, just manual selection?

     

  • Avatar
    Awesome Table

    Hello Jeroen Baert,

    you can use this keyword in this way : buttonType(A,B)

    When you reference a column as the button color, it will pull the value of this column for each column as the button's color.

    Nicolas

  • Avatar
    Jeroen Baert

    Simple and elegant, strange I did not think of that. Thanks!

  • Avatar
    Clément Thirode

    Hi,

    With ButtonType is it possible to define target property to "_self" so that the link open in the same window?

    Clement

  • Avatar
    Awesome Table (Edited )

    Hi Clément,

    You need to use "target=_top" instead of "target=_blank" to open the link in the same window.

    Thomas

  • Avatar
    Clément Thirode

    Hi Thomas,

    Thanks for your reply, but where can I put this parameter?

    I followed your example so in my data sheet, I have one column with urls (say column A) and another which name is Book and type is typebutton(A,COLOR). In the template I only use {{Book}} to show the button. 

    So I have no reference to a html <a> link to insert target=_top parameter

    Does that make sense or I'm missing something?

    Clement

  • Avatar
    roshind vp

    Hi
    How to change color of the button after click?

    roshind

  • Avatar
    Awesome Table

    Hello Clément,

    I'm sorry, I forgot to specify it is unfortunately not possible for some reasons security.

    So you have to create your button with HTML and CSS.

    Thomas

  • Avatar
    Awesome Table (Edited )

    Hello Roshind,

    If you want to change the color of your button after click, you have to inspect the code to find out which class you need to change. You also have to add the property ":visited" to this class in your template sheet (https://www.w3schools.com/cssref/sel_visited.asp).

    Here is an article that explains how to use inspector on chrome: https://developers.google.com/web/tools/chrome-devtools/inspect-styles/ .

    Thomas

  • Avatar
    Admin

    Hello,

    is it possible to create link to another list of the same sheet? or to another filtered view in awesome-table (in the same browser panel)?

     

    thanks

  • Avatar
    Awesome Table

    Hello Admin,

    I'm not sure to understand what you want to achieve. Could you please provide us more details?

    Thanks in advance.

    Thomas

  • Avatar
    Eddie Taliaferro

    Question, 

    How can I get the buttonType to execute every time a new record is added to a awetable table from a google form?

    When I add a new record, I need to manually type "Open Document" in the column using the "buttonType" keyword. 

     

    Thanks, 

    Eddie

  • Avatar
    Awesome Table

    Hi Eddie Taliaferro,

    Unfortunately, it is not possible to add a buttonType automatically with Google Form. The only button displayed automatically is the "edit" button.

    Kind regards,
    Thomas

  • Avatar
    Kimberly Reaume

    When I do an advance parameters query my buttonType no longer works.  How do I get it to only display the necessary columns and still get the button to work for my link without writing script into my spreadsheet?

    Thanks,
    Kim

  • Avatar
    Kimberly Reaume

    Nevermind, I found I could hide all the columns by using keyword Hidden in each column and then just doing an advance parameters query for 'Select * where I is NULL' instead of listing all the Select columns in my query.  This gives me my filter and hides all unnecessary columns.

  • Avatar
    Awesome Table

    Hi Kimberly,

    I'm glad you solved your problem!
    Do not hesitate to contact us if you have additional informations.

    Kind regards,
    Thomas

  • Avatar
    Samantha Pikero

    Hey I have a question,

    I have a form set up where people have to write a short abstract. In the awesome table however I want that short abstract to be hidden and instead a button to be shown and when they click on it a modal would display with the text.

    I got the button to display but I have no idea how to link it to the text which is located in the same sheet as the rest of the data displayed in the awesome table. How do I link them?

    Also this is an awesome table that is generated by a form so I would ideally like it to automatically display the button instead of the text without having to manually go in and select the text it's supposed to show. Is that possible? 

    Thanks in advance!

    Samantha

  • Avatar
    Awesome Table

    Hi Samantha Pikero,

    Indeed, it's possible to do this but it requires knowledge in code especially in JS.

    I suggest you consult these articles:
    - Modal Text
    - Toggle Hide and Show

    To display automatically your button in your Awesome Table view, you can look in our Google + Community. We have a lot of moderators and maybe some of them have already used a button like this.

    Kind regards,
    Thomas

  • Avatar
    Afschqtraining

    Hello- I have a few questions:

    How can I expand the width of the button (and center it)?

    And, is there a way to assign an email title to populate once the button is clicked, and a new email is opened with the predetermined recipient?

  • Avatar
    Awesome Table

    Hi Afschqtraining,

    If you need to customize your button, you can inspect the code and use CSS in your template sheet but it requires knowledge in code. Moreover, I don't suggest to abuse the CSS because if we make some changes in the code, it will affect your view.

    To open an email box you can consult this article but your users have to accept this parameter. Here is another article that could be useful for you.

    Kind regards,
    Thomas

  • Avatar
    Afschqtraining

    Thanks for the quick response, Thomas!

    We have a few more questions that tie-in:

    Is there a way to have the email hyperlink generate a subject line once it's opened?

    Is there a way to make an email hyperlink active in the tooltip on the map?

    Is there a reason why the map itself wouldn't load in Safari/Chrome, but would work in Firefox?

     

    Here's what we're working with:

     

    https://awesome-table.com/-L8Ym_gUktnyjIHKh8Wi/edit

     

    Thanks again!

    -David

  • Avatar
    Awesome Table

    Hi David,

    Indeed it's possible to generate an email hyperlink active. I suggest you consult this article that explains how to open an active email. However your users must have certain parameters enabled in their web browser.
    I also made a try with your view on Chrome and Safari and it works perfectly for me. You need to check if your browser left some bugged cookies. Here is an article that could be useful in your case.

    Kind regards,
    Thomas

  • Avatar
    Stephanie Finley

    I am using Google Sheets and AwesomeTable to create a catalog system for our science center. This catalog system will also be used to check out materials. Once a patron clicks on the "Reserve" button, which will lead to a Google Form to check out the item, how can I make the button inactive once the item is checked out so they know the item is not presently available? And if that is a possibility, when the item is checked back in, how can the button be re-activated? Thanks!

  • Avatar
    Francesca G

    Hello!
    Is it possible to add two buttons in a single cell?

     

    Thank you!

  • Avatar
    Awesome Table

    Hi Stephanie Finley,

    Unfortunately, it is not possible yet to activate or disable the button once it is set up.

    Kind regards,
    Thomas

  • Avatar
    Awesome Table

    Hello Francesca G,

    Indeed it is possible to add 2 buttons in a single cell if you use an HTML template. Here is an article that could be useful for you.

    Kind regards,
    Thomas

  • Avatar
    Francesca G (Edited )

    Hello Thomas, 

    thank you for your reply. With your advice, I got to display both buttons in a single cell!

    But I don't know hot to setup my query. Before I was loading two columns for the buttons with this select
    select A,B,C,O,F,M,I,K,J,N
    where I and J are the links columns, and  K and N are the buttontype columns.

    I get to display my "two button column" P if I add P ad the end of the select, but not if I delete the single buttons.

    I tried with:

    • A,B,C,O,F,M,P
    • A,B,C,O,F,M,I,J,P
    • A,B,C,O,F,M,K,N,P

    But none worked. I feel dumb.... but can you help?! Thank you!

  • Avatar
    Awesome Table (Edited )

    Hi Francesca G,

    It will be difficult to understand your problem if we don't know the type of the view you use. 

    Would it be possible for you to share your Awesome Table view and your spreadsheet at "[email protected]"? If you have sensitive data, you can make a copy with similar data. 
    Please, just make sure you give access to your data.

    Kind regards,
    Thomas

  • Avatar
    Francesca G

    Thanks to the amazing AT support I came to the solution and share it here. While the query is correct with all the columns, I need to add - Hidden to the two buttonType columns.

    Thanks again Thomas!

  • Avatar
    Marcelo

    Hello! One question regarding mailto: links: it is possible to use ButtonType with mailto links? So far I´ve tried and only recognize http or https links. Or in other words, how can I include a link or a button that sends an email?