Skip to content
postpone the task from 7, 30 or 365 days. Here are the formula for x+7delete the rowopen the link of the row
Hi there ! Buttons are one of the must wonderful feature, a real change maker compared to its concurrent. We can need it for a lot of use case, in global document, but also to manage tables row !
This little post is about the second use case, when you start to have soooo many buttons in your table that the “card” view start to look a little cluttered
A classic table, with classical Buttons
As you talk about buttons, let’s consider a basic use case, whith a to-do-list, and a button to manage the date your task to :
ModifyRows(thisRow, Tasks.[Due Date], thisRow.[Due Date]+7)
DeleteRows(thisRow)
OpenWindow(thisRow.Link)
Tasks
Task
Due Date
Link
Tomorrow
Next Week
Delete Row
Open the Link
There are no rows in this table
OK, as long as you stay in the table mode, it’s quite OK, but when you start to use the “cards” mode, there are lots of data to deal with, and we’ve to admit that it’s not very aesthetic.
The buttons are all in a column, and it can be really space-consuming !
Wrap it guys !
This little trick aims to create a new columns, called for example “WrapButtons”, in order to concatenate buttons, and then optimize the display !
This trick require to use the experimental function button() inside a Concatenate() function.
As far as I searched, you won’t find these in the official , so be careful with the use, as it’s unofficial 😉
The syntax of button() function is quite easy, but remember : it requires that you already have an existing button in your table (here the ‘value’ information)
Let’s apply this to our example, with a first basic configuration (you can try to play with button() options, that is not the purpose of this trick!), calling the four buttons of my table. Let’s create a “WrapButton” column, formated as text with this formula
Concatenate(
button(thisRow.Tomorrow,"+1","Blue")," ",
button(thisRow.[Next Week],"+7",color: "Green")," ",
button(thisRow.[Delete Row],"Delete","Red")," ",
button(thisRow.[Open the Link],"Open")
)
That will create this new column :
Task
Due Date
Link
WrapButtons
There are no rows in this table
And finally switch to card view, and this is it. Better isn’t it !?
Size improvement !
Hope you enjoy this little trick ! Please visit to leave any comment, suggestion, or see my twitter feed !
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.