The button field is an interactive column type that lets you trigger certain actions directly.
Adding button: Select button column type
Select button label you want and type URL formula, or just URL
Current Button field actions
1. 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:
1. Post a Tweet
Need 1 column: Tweet Text
CONCAT("https://twitter.com/intent/tweet?text=",ENCODE_URL_COMPONENT({Tweet Text}))
2. 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})")
3. 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")
4. 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")
5. Open a Stackby Form with pre-fill 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}))
