Introducing Button Column Type

Imagine you are dealing with your social media calendar on Stackby and you can post a tweet directly from your table with just button click! Your work will become hundreds of times easier and automatically.

Here is another scenario. Imagine that you are dealing with an application tracking system and now you have to send a specific email to all the shortlisted candidates. Instead of opening the email app, you Just click a button On your table, whoosh! your email has been sent!

It’s time to welcome you Stackby button column type In workflows to complete certain actions from the same schedule.

Introducing Stackby’s Stackby’s Powerful Multi-Purpose Button Column Type

You may already be aware that the different column types in Stackby enable you to visualize and organize your data in your table. Stackby comes with 50+ column types like short text, long text, single/multiple selection, date, time, duration, progress bar, link, formulas, and much more. Each column type helps you customize how your data is stored.

The button column type is another jewel in the crown. It is an effective way to start an action based on your data and business requirements. With the click of a button in the Stackby table, you can do the following:

  • Tweet directly from your table
  • Send an email via Gmail
  • Create a Google Calendar invitation for a specific date and time
  • Create a Google Calendar invitation for a specific date
  • Open a Stackby form with pre-filled row content
  • Create any custom action using a wide range of URL formats using functions like CONCAT, ENCODE_URL, etc.

Stackby’s button column type makes your work much easier by eliminating redundant steps in your workflow. In other words, you automate your redundant tasks and create a streamlined workflow. Above all, using the button column type is simple for anyone, whether you are a master stacker or a newbie to Stackby.

How to use the column type button in Stackby

Now let’s break down how you can configure the button column type in your table. From the list of selected columns, you need to select a button. This column type comes with three characteristics:

Understanding button column type in Stackby

1. Label the button: This is how your button will be displayed in the table. So you can change the label as per your action. For example, you can type “Open URL”, “Send Email”, “Post”, “Create Event” and so on.

2. Button color: Give your button a vibrant color and brighten your workflow. You can choose from over 30 color options available in our color palette.

3. Format URL: This is where all the work happens. In this property, you must enter the formula that will be executed when the button is clicked. You can choose a format that fits your action and start with the button column type.

Explore some ways on how to use the Button Column Type in workflows

1. Post a Tweet directly from your Stack schedule

Post a Tweet using the button column type

The first action we’ll explore is to post a tweet from your table with a button. For this you need one column containing the text of the Tweet.

Now, you can create and setup a new button column type in the following ways:

  • Change the label to Send Tweet
  • Choose a color for your button
  • Write the formula as follows:

CONCAT(“https://twitter.com/intent/tweet?text=”, ENCODE_URL_COMPONENT ({Tweet Text}))

Your button is configured to send tweets!

Explores: Stackby Social Media Calendar Template

2. Send an email through Gmail

To send an email via Gmail, you need three columns. One includes the email ID, the second includes the email subject, and the third includes the email body.

Send email by button column type

You can now create and setup a new button column type in the following ways:

  • Change the label to send mail
  • Choose a color for your button
  • Write the formula as follows:

CONCAT (“https://mail.google.com/mail/u/0/?view=cm&to=”, ENCODE_URL_COMPONENT ({Email}), “& su =”, ENCODE_URL_COMPONENT ({Subject})), “& body = “, ENCODE_URL_COMPONENT ({Body}))

Explores: Stackby Email Marketing Template

3. Create a Google Calendar invitation for a specific date and time

To create a Google Calendar invitation for a specific date and time, you need three columns in your table. One includes the name of the event, the second includes the start date and time of the event, and the third includes the end date and time of the event.

Create a Google Calendar invitation for a specific date and time

You can now create and setup a new button column type in the following ways:

  • Change the label to Create Event
  • Choose a color for your button
  • Write the formula as follows:

CONCAT (“https://calendar.google.com/calendar/render?action=TEMPLATE&text=”, ENCODE_URL_COMPONENT ({Name})), “& date=”, DATETIME_FORMAT ({Start Date / Time},” “YYYYMMDDTHHmmss”), “Z%2F”, DATETIME_FORMAT({date/time}, “YYYYMMDDTHHmmss”), “Z”)

Discover: Online Event Tracker Form Pre-built by Stackby

4. Create a Google Calendar invitation for a specific date

To create a Google Calendar invitation for a specific date and time, you need three columns in your table. One includes the event name, the second includes the event start date and the third includes the event end date.

You can now create and setup a new button column type in the following ways:

  • Change the label to Create Event
  • Choose a color for your button
  • Write the formula as follows:

CONCAT (“https://calendar.google.com/calendar/render?action=TEMPLATE&text=”, ENCODE_URL_COMPONENT ({Name}), “& date=”, DATETIME_FORMAT ({Start Date}”, “YYYYMMDD””), “%) 2F”, DATETIME_FORMAT(DATE_ADD({End Date}, 1, “day”), “YYYYMMDD”))

5. Open a Stackby form with pre-filled row content

To open a Stackby form with pre-filled row content, you need all the columns that need to be filled in in your form. Then, you can configure the button column type as follows:

  • Change the label to Open Form
  • Choose a color for your button
  • Write the formula as follows:

CONCAT(“https://stackby.com/form/frshr16327442818961e023e?prefill_”, “(First Name)”, “=”, ENCODE_URL_COMPONENT ({First Name})), “& prefill_ (Last Name) =”, ENCODE_URL_COMPONENT ({{) Last name}))

Read more: Enter Stackby Forms

Easy isn’t it? Try our button column type once and you’ll never look back. It is designed to facilitate workflow like never before. If you’re new to Stackby, sign up for free and set up your business workflows right away. We also have close to 300 pre-built templates to get you started.

Leave a Comment