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.
Nesta página do site você pode assistir ao vídeo on-line Conditional Formatting in List. Kaizen Framework. Low Code Framework. duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário Kaizen Framework. Low Code, Rapid Development Tool 15 Novembro 2022, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 126 vezes e gostou 1 espectadores. Boa visualização!