joelgabauer - profile

joelgabauer · Oct 19, 2020

Hi All, I’d like to create a unique number for a record based on the year and week. So for example, I have a date field which I use as YEAR(Date)&" - "&WEEKNUM(Date). So if the date was today this would give me an output of 2020 - 43. Now, I want to ...

joelgabauer · Nov 15, 2021

Although not ideal, you can create a text field and hyperlink it to a form that creates a new record in the base you are in.

joelgabauer · Oct 20, 2020

Thanks so much! I got this working.

User Statistics

User Activity

Unique number using year and week numbers

Re: How to add a new record from an interface?

Re: Unique number using year and week numbers