2022.2

FormattingvaluesinaDynamicTable
ValuesinDynamicTablecellscanbeformattedindifferentways.Adatevalue,forexample,couldbe
displayedas"Apr2,2016"(shortdate)or"4/2/1612:00AM"(mediumdate/time).
Whichformatsarepossibledependsonthedatatypeofthefieldthatcontainsthevalue(see"Data
types"onpage275).
Selecting a format
Theformatofeachvaluecanbechosenwhencreatingatable.Foranexplanationofthepossible
formatssee"Formattingvariabledata"onpage732.
Howyouchangetheformattingofvaluesinanexistingtabledependsonwhetherthecellorspancon-
tainsanexpressionorisdirectlylinkedtoadatafield(see"Expressionsorplaceholders?"on
page747).
Ifthecellorspancontainsanexpression:
l
Thereisanumberof"FormatHelpers"onpage769thatyoucantypeinanexpressiontoformat
theoutputdifferently.
Ifthecellorspanhasadirectlinktoadatafield:
l
SelecttheelementthatcontainsthevalueandthenusetheFormatdrop-downonthe"Attributes
pane"onpage969.
l
Openthe"Sourcetab"onpage989andmanuallyaddthedesiredformattothecellusing
thedata-formatattribute(see"ADynamicTable'sdata-attributes"onpage755).
HidinganemptyDynamicTable
ThenumberofrowsinaDynamicTableisvariable,asitdependsonadetailtableinthedata.
Youcanhideatablethatdoesnotcontainanydata.Therearetwowaystoachievethat.
l
WhencreatingaDynamicTable,youcanchecktheoptionHide when empty.(See"Creatinga
DynamicTable"onpage742.)
l
ForanexistingDynamicTableyoucanselectthetable(see"Selectinganelement"onpage570)
andchecktheoptionHide when emptyonthe"Attributespane"onpage969.
Hidinganemptytablerow
Empty rowsareomittedfromaDynamicTablebydefault.
Arowisconsideredemptyifallelementswithadata-fieldattributeinthatrowrefertoemptydatafields.
Anyadditionaltextisnottakenintoaccount.
Tokeepemptyrowsvisibleintheoutput:
Page 752