WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > User Voice > Latest posts

User Voice

MVP
In reply to: Daniel Krüger (Cosmo Consult)

Hi Maks,

It’s just something I came up with but I haven’t tested it, maybe you can check whether you can reference a variable in the style property. This way you could add the variable value to the custom themes.

Best regards,
Daniel

Hi Daniel,
already tried it, without success unfortunately.
Webcon uses Chroma.js to validate if color is hex or standard named color, there is a `valid` function, which calls for `color` class instantiation and this one prints an error in console.
At least that's what i think is going on :)

* https://gka.github.io/chroma.js/
* https://github.com/gka/chroma.js/blob/fdab658c5013a924db2cc9c89d9ac1d7d1382cd9/src/utils/valid.js
* https://github.com/gka/chroma.js/blob/fdab658c5013a924db2cc9c89d9ac1d7d1382cd9/src/Color.js#L32C1-L41C19

Hi.

we've implemented some global form rules e.g. a developer on screen mode that displays meta data of fields (instead of turning on dev tools) - a knowledge base article will follow later. Small work in progress preview teaser in the attached screenshot. ;)

Right now it is necessary to add this global form rule to all main form behavior sections manually to get this loaded.

It would be great if one would have a global function in system settings like it is for global CSS for form rules that shall be loaded for all forms automatically when set. Maybe it could be realized like it is with data sources. This means one has to connect a global form rule in system settings to forms individually or with the global option "load global form rule to all forms". The last idea would just need a new checkbox in global form rule configuration "load for all forms" or a configuration "load for all selected forms". The "load for all forms" global form fields could be displayed greyed out (read-only) in the main form behavior section.

What do you think about?

Kind Regards
Sébastien

MVP

Hello,
since the new UI we've got much more users on the dark theme of webcon, it brought however a few new challenges with custom colors on controls / lists.

At this moment we are able to set custom css styles - background/text using attribute configuration:
https://docs.webcon.com/docs/2025R2/Studio/Process/Attribute/General/Attribute_StyleAndBehavior

It however lacks the possibility to make the color dependant on the theme, which causes in many cases unreadable text - see attached examples.
In most cases we're just switching colors to have contrast somewhere in the middle to both Webcon themes, so it looks equally ugly on both of them :)

Maybe a possibility to define a custom global css properties through system configuration, and use those properties in those configs would be something possible to implement?
Or from another angle - add possibility to define custom css properties on Theme configuration page?
https://docs.webcon.com/docs/2025R2/Portal/Administration/ColorThemes#edit-themes

MVP

Hi,

while we can create business rules which act similar to table valued / scalar functions, we can't pass the columns/data to them. The inner business rules are executed before the outer SQL command is executed. This comes in really handy in a lot of cases but also has it's limitation and will require creating repetitive code.

I would suggest the following:

Create a new "type" "SQL function"

Properties would be similar to a business rule:
Name : GetFirstTextPart
Description: Will split the text by the line break character and return the first part of the text. If no line break character is present, the input will be returned.
SQL Command
CASE
WHEN CHARINDEX(CHAR(10), {Parameter:1}) > 0 THEN LEFT({Parameter:1}, CHARINDEX(CHAR(10), {Parameter:1}) - 1)
ELSE {Parameter:1}
Number of rows to return: First row (scalar function), all rows (table valued)
Parameters:
Name: Input
Description: The complete text with the line break character.

When this is saved a function scalar/table valued is created and the bps_user gains execution permissions.

CREATE FUNCTION dbo.GetTextPartEN(@input NVARCHAR(MAX))
RETURNS NVARCHAR(MAX)
AS
BEGIN
RETURN
CASE
WHEN CHARINDEX(CHAR(10), @input) > 0 THEN LEFT(@input, CHARINDEX(CHAR(10), @input) - 1)
ELSE @input
END
END


You could then use the variable of this new type like the other business rules
select *, {SQLFunction:1700:<xps><ps><p id="#SQLFunctionParameter:71#" v="Description" /></ps></xps>} as DescriptionEN
, {SQLFunction:1700:<xps><ps><p id="#SQLFunctionParameter:71#" v="Remark" /></ps></xps>} as RemarkEN

Which would resolve to
select *, dbo.GetTextPartEN(Description) as DescriptionEN,dbo.GetTextPartEN(Remark) as RemarkEN

This came only to my mind now, because I'm creating a lot of "repetitive statements" in a few data tables, but when I think back, it would have helped me in a lot of other cases two.

Best regards,
Daniel

Privacy overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognizing you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.


To see a full list of the cookies we use and learn more about their purposes, visit our Privacy Policy.