Hi,
To apply conditional formatting to List records.
You can follow the steps as below.
Goto List edit properties by clicking on the pencil icon next to List.
In your query you have to put this case which will apply the formatting to the row.
Create VIEW [dbo].[Vlistkz_CountryMaster]
AS
SELECT CountryId,
CountryName as Country Name
, CountryCode, Remarks, CASE WHEN IsActive = 1 THEN 'Active' ELSE 'Deactive' END AS IsActive, kz_CompanyId, kz_LocationId, kz_UserId
,
case when IsActive=0 then
'style="background-color: red !important;"'
when select count*from kz_StateMaster where CountryId=kz_CountryMaster.CountryId=0 then
'style="background-color: orange !important;"'
else
'style="background-color: blue !important;"'
end
kz_RowFormating
FROM dbo.kz_CountryMaster
GO
The above example is for changing the background color of, you can define any style to the row.
You can have multiple conditions for formatting the row.
https://Kaizenframework.app
#lowcode #lowcodeplatform #lowcodeframework #rapidapplicationdevelopmenttool #radt
#Kaizen #Framework is a #lowcode, rapid application development tool. You can skip the coding, publishing, uploading task for making the software. You can save time and money while making complex web applications.
Download and start using Kaizen now.
En esta página del sitio puede ver el video en línea Conditional Formatting in List. Kaizen Framework. Low Code Framework. de Duración hora minuto segunda en buena calidad , que subió el usuario Kaizen Framework. Low Code, Rapid Development Tool 15 noviembre 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 126 veces y le gustó 1 a los espectadores. Disfruta viendo!