Format columns
Link
Display your link sin onleetable
Syntax
url, [anchor]
url - The full url of the page to open, must be a full https url not a reference to another cell.
anchor - [ OPTIONAL - "Link" by default ] - The anchor of the hyperlink text.
If not specified we apply a default "Link" value.
Sample Usage
In Google Sheets
In onleetable
Image
Display your pictures in onleetable
Syntax
url, [alignment]
url - The public url of your image.
alignment - [ OPTIONAL - "center" by default ] - Select how your picture will be aligned in the row.
If not specified we apply a default "center" value.
Accepted values are : left, center, right
Sample Usage
In Google Sheets
In onleetable
Button
Display your pictures in onleetable
Syntax
url, [label],[width],[color])
url - The full url of the page to open, must be a full https url not a reference to another cell.
label - [ OPTIONAL - "OPEN" by default ] - The text to display in the button.
If not specified we apply a default "OPEN" value.
width - [ OPTIONAL - "100%" by default ] - Width of the button, can be a % or px value.
If not specified we apply a default "100%" value.
Better to use % value to adapt better on screen.
color - [ OPTIONAL - "#2f2f2f" by default ] - Color of the button.
If not specified we apply a default "#2f2f2f" value.
The text color of label will be adjust between black and white to fit the background color better contrast.
Sample Usage
In Google Sheets
In onleetable
In the first example we don't define specific parameters so the button is rendered with defualt valuer.
In the last example we did not define a size so the default 100% has been applied.