To navigate to edit screen.
//Select(Parent)
Set(record, ThisItem); EditForm(FormNewEdit); Navigate(scrForm)
To navigate to New screen:
Icon +, onSelect , ResetForm(FormNewEdit); NewForm(FormNewEdit); Navigate(scrForm, ScreenTransition.Fade)
Set the Bg of the selected row
TemplateFill: If(ThisItem.IsSelected,RGBA(0, 120, 212, .2),RGBA(0, 0, 0, 0))
or
If(ThisItem.IsSelected,WhiteSmoke,White)
Format Currency column:
[code] If(IsBlank(ThisItem.’col name’),
"",
"$" & Text(
Value(ThisItem.’col name’),
"[$-en-US] #,##0.00"
)
)
[/code]