Field labels in RED color

Vermaji , 

I agree with you. It would be nice to be able to change the appearance of the labels in all fields and have the "Style" option available in them, as is done with the "Formula" fields.

Who knows? Maybe we will see some of these features in the upcoming Ninox 3.13 release!

Vermaji , you can do the following:

• As Alan Cooke suggests, you can create labels by using formula fields. Put inside them something like: html("<strong style='color:red;'>Customer Name</strong>").
• Use a Heading Layout element for the section divider and format it accordingly.
• At least for the choice fields, you can use the name as a placeholder.

Vermaji ,

I have post a new topic: How to insert Line Dividers into a page or table form

Alan Cooke hi, or you can put the field name as a placeholder like the screenshot below

Vermaji , sure it seems no logical but on the other hand this is the Ninox logic, this is the Ninox way of doing things.

My understanding is that inside every Ninox table we do not only store raw data but also the “data” regarding the presentation of our “raw data”.

I am not sure if the above make sense to you but don’t be afraid to add as many fields as you like into your tables!

Sean this is really awesome! Thanks 

What is not obvious to me is how I choose the field to which I want to apply the new settings. For example, in your demo database, how can I apply the red label to the 'text' or 'number' field?

Sotirios Zormpas you just need to set any field's Required setting to Yes. Ninox just adds or removes the error class based on whether the required field is empty or not. You will see that the styling disappears if the required field is filled and that is because Ninox removes the error class and then the style classes in the CSS no longer match.

Sean I see…excellent. Thank you for clarifying this 

Sean Hi Sean

Is there a way to change the required status with a script. 

Example if Date < DataDate required (yes)

Rafael The best I can do at this point is change the label color and background color. The error text would be difficult for me to modify. Maybe a tooltip? That's more Jacques TUR purview.

if Date < date(2024, 7, 19) then
    html("
    <style>
        .component.editor.editor-date label {
            color: red;
        }
        .component.editor.editor-date {
            background-color: lightgray;
        }
    </style>
    ")
end

Sean 

Hi Sean

Definitely it doesn't work with date fields.

if date('Plan 1') < date(DataDate) then
    html("
    <style>
        .component.editor.editor-date label {
            color: red;
        }
        .component.editor.editor-date {
            background-color: green;
        }
    </style>
    ")
end

Hi Rafael 

I don't post solutions that don't work for me at the very least. I have attached a simple demonstration database with two date CSS options. I understand the hardcoded date example is not practical and was more of a proof of concept.

For anyone who wants to use CSS inside Ninox if-then statements, you will need to use separate Formula fields for each condition. Otherwise, any previous CSS will be ignored.

Sean 

Thanks Sean 

Vermaji Hi,

Vermaji said:
It's just that this code changes the background colour and the label colour for all the required fields on the form right from the start i.e when a new record is added.

This is consistent with how Ninox handles Required fields. Without the added CSS, all Required fields still have a red border. That is the behavior for both existing records and new records.

Vermaji said:
Ideally it should only change the background and foreground colours only if we do not enter anything in the required fields. Initially when the form is opened or a new record is created, all fields should look normal.

This is a UX design decision by Ninox and I don't think CSS alone can override it. What you want requires JavaScript and it would be far easier for Ninox developers to implement. Even if someone came up with a JavaScript solution, I believe it can only be triggered by a button which wouldn't be very practical.

Vermaji said:
To achieve this, I moved the code from the formula field to the auto Trigger of the second Text field ("Trigger after update") and realised that the code does not work. Then I moved the code to the auto Trigger of the Table ("Trigger after update") thinking that the code will execute when we save the record, however it still does not work.

A field's content must be changed to activate Trigger after update. Simply tabbing through won't do it. If you were able to get it to work with the table level trigger how would you know which field(s) to highlight?

For what it is worth, users aren't able to save records. This is another Ninox design decision. Users can create, modify and delete records.

Vermaji said:
I really can't understand that the code that works in the formula field, why doesn't work in the Trigger ?

 The html() function doesn't work in tables either.

Sean Hi,

html("
    <style>
        .component.editor.editor-string input {
            color: yellow;
            background-color: red;
        }
    </style>
    ")

Playing around, I discovered that I could use the code above to modify the text color and background color of the input area in a text box when the focus is on it.

How can I achieve the same effect inside the input area when the focus is out of the text box (see text 2 below) ?

Sotirios Zormpas Hi,

.nx-input works for the Text field and some of the other fields as well.

html("
    <style>
        .nx-input {
            color: yellow;
            background-color: red;
        }
    </style>
")

You can also use .nx-input__input instead when the field has focus.