Conditional formatting

[dom]

Hello
Is condiional formatting available in layouts ?
Thanks.

[Brendan]

Hi Dom,

No, I don’t have conditional formatting other than on Number fields you can have it display a value in red for negative numbers.

What sorts of rules are you looking for around that?

Thanks,

Brendan

[dom]

Hi Brendan
This is a typical example regarding owner-dues. I have 2 reference numbers. One for general owner-dues, one for special works. I am checking the account of each owner with both reference and formatting what each owner is supposed to have paid.
FYI the attached table with conditional formatting comes from GRIST
Thanks

Attachments:

You must be logged in to view attached files.

[dom]

GRIST doc on conditional formatting.
https://support.getgrist.com/conditional-formatting/

[David]

I’m new here (still in evaluation), but would just like to second this suggestion to implement conditional formatting and field display in layouts. I don’t know how difficult it is to implement, but there are a number of great use cases where, perhaps, a checkbox entry for a record drives display of additional fields. This is especially valuable on phone/pad layouts where real estate is at a premium.

Thanks

/dpw

[Brendan]

Hi David,

Thanks for the feature suggestion. So you’re asking for both conditional formatting AND conditional display? So a field would be hidden or shown based on the value of some other field?

Thanks,

Brendan

[David]

Yes, both. Here’s a screenshot of the Ninox “layout” editor for a simple database that I created to log road trip data showing a “Gallons” field to record fuel purchases at a stop (1). That field and the associated cost field is only shown if the stop is flagged in the “Fuel” boolean field (2).

I’m thinking about migrating off of Ninox.

Thanks,

/dpw

Attachments:

You must be logged in to view attached files.

[Brendan]

Ah, interesting. So your condition just says “Fuel”. Does that imply that the Fuel field must be YES in order for the Gallons and Cost fields to display? Or does the formula show as “Fuel = YES” or something like that?

It’s definitely something that would be interesting to work on. Not sure how well it would work for a custom layout as the position of items are fixed (other than they’d simply disappear or appear). But the Default and Universal Layouts could work.

Thanks,

Brendan

[David]

Yes – “Fuel” is a boolean variable/field (i.e. value is either 1 or 0), therefore it can be used by itself in a conditional expression.

Thanks for taking a look at it. I look forward to learning more about your system.

[Brendan]

Conditional formatting is coming…

Attachments:

You must be logged in to view attached files.

[dom]

Super!

[Author]

Posts