Help Please

Use styled() to set the color of text and the background. You can use if statements or a switch case to set the text color based on the experation date.

styled(text, bgColor, color, icon)

styled(text, colour, icon) - creates styled text elements. The icon is placed to the left of the text. Use "" for none, and the colour is the objects background
|  styled("Attention", "red", "warn")

To create the experation date add 14 to the date.     Date + 14

for a unique auto incremented index, see this thread:

https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/data-field-types-5ab8fe445fe2b42b7dd39f67?post=5ab8fe5e5fe2b42b7dd3a7fe&page=5

Birger Hansen
Wednesday, April 26, 2017 12:24 PM
This is possible.
1. with a trigger "onCreate" on table level with this formua:
–––
uniqueNumber := max((select Table1).uniqueNumber) + 1
–––
or - if you just want to check if the number is unique after update put this formula to the "onAfterUpdate" trigger of the field:
–––
let myTest := 'Auto increment Number';
if cnt(select Table1[uniqueNumber = myTest])>1 then "not unique" else myTest
–––
Birger - Ninox Support

For expiry date create formula field:

--

YourDateField +15

--

For highlighted fields I use something similar for invoices:

--

let dd := Date + Customer.Terms;
let pd := 'Pay Date';
if pd = null then
styled("Not Paid", "orange", "")
else
if pd > date(dd) then
styled("Overdue", "red", "")
else
styled("Paid", "green", "")
end
end

--

Just change Fields and colors.

Nick

Create new Formula field and:

Nick

Edit fields 

new field

formula