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.
On this page of the site you can watch the video online Conditional Formatting in List. Kaizen Framework. Low Code Framework. with a duration of hours minute second in good quality, which was uploaded by the user Kaizen Framework. Low Code, Rapid Development Tool 15 November 2022, share the link with friends and acquaintances, this video has already been watched 126 times on youtube and it was liked by 1 viewers. Enjoy your viewing!