Column Type - Button

The button field is an interactive column type that lets you trigger certain actions directly.

In this article, you will learn

1. Adding button

2. Open URL

3. Page Designer

Adding Button: Select Button Column

Select button label you want and type URL formula, or just URL

Current Button Column Actions

Open URL

The Open URL will open a link where the URL can be based on values from your record. Clicking will send you to the URL in the new window.

More, you can enter a URL formula. This uses the same formula syntax as the existing formula column and supports using cell values from other columns. 

Few example button actions: 

a. Post a Tweet

Need 1 column: Tweet Text 

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

b. Send an email through Gmail 

Need 3 columns: Email, Subject, Body

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})")

c. Create a Google Calendar Invite for a Specific Date and Time 

Need 3 columns: Name (for Event Name), Start Date/Time, End Date/Time

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

d. Create a Google Calendar Invite for Date Only

Need 3 columns: Name (for Event Name), Start Date, End Date

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

e. Open a Stackby Form with Pre-filled Row Content

Need 2 columns: First Name, Last Name (you can add as many pre-fill parameters the same way)

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

Adding Buttons to open Page Designer App

The Button Column in Stackby can be integrated into a custom layout using the Page Designer app to create interactive pages or documents, such as reports, catalogs, or client profiles, where each row in a table is presented in a visually appealing, printable format. 

Steps to Create a Button Column with Page Designer Action

1. Add a Button Column: In the column properties you’ll see the following options:

   Label: Enter a label for your button

   Style: Choose the appearance (color and style) of the button. 

2. Set the Action to Page Designer: Choose Page Designer. This allows the button to open a custom layout created with the Page Designer app.

3. Configure Dashboard and App: You will see two options: Dashboard and App.

   Dashboard: Select the specific dashboard where your Page Designer app is installed.

   App: Choose the Page Designer app from the available apps in your dashboard.

If you haven’t installed the Page Designer app yet, you can click the Install link next to the App field and follow the steps to install the app.

4. Save the Configuration:

Once you’ve configured all the options, click Save to apply the Button Column.