Hello everybody, I have been using a formula to generate invoice numbers, but is has been producing some overly similar looking numbers which confuses clients. Current formula is: “INV” & DATETIME_FORMAT(CREATED_TIME(),‘msw’) What I’d like to change ...

Hello, I’m trying to see whether it is possible to create a single select field that only shows “Products” from a column if they are a “Current” line to be used on a form. The single select field on my form shows all “Products”, regardless of whether...

Hi, I’m quite new to formulas and I am having a little trouble getting a DATEADD formula to work I am setting up some formulas for a Page Design invoice and need: ‘Today’s Date’ ‘Due Date’ 14 days from ‘Today’s Date’. My formula for ‘Todays’ Date’ is...