ContributionsMost RecentMost LikesSolutionsDefault Value on Text-MultipleChoice-Lookup FieldHi there! I use QuickBase to keep track of projects, (project title, project number, etc.). I have a field called project status that has its own table and in the project entry table I created a relationship connecting them so that when entering a new project you could choose the project status from the list of options (active, complete, dead, etc.). Since every time we open a new project, I would like the default value of the field to be "Active" however I cannot figure out how to do that under a text-multiple choice-lookup field. I know there is a spot for a default value under a normal list. Any help would be much appreciated! Thanks! ------------------------------ Brandon Bolino ------------------------------ Automated Project NumberHi there! I use QuickBase to keep track of projects, (project title, project number, etc.). I have a field called project number that takes the last two digits of the year ("YY") and the sequential number of projects that have taken place that year ("XXX"). So if I were to begin working on my third project of the year the project number would be "20003." I am running into problems making this automated, I want to format the field type so when a new project is started the project number is automatically generated. I don't know what field type to choose, I have tried to do it with a numeric formula but am unsure of what code to type. Any help would be much appreciated! Thanks! ------------------------------ Brandon Bolino ------------------------------