Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Primary Records & Forms: can the primary field be auto-generated?

Topic Labels: Base design
433 3
cancel
Showing results for 
Search instead for 
Did you mean: 

I am hoping to design a form that our hourly staff members can use to submit their hours worked at the end of each pay period.

Is there a way that I can have the necessarily unique primary field be autogenerated, so that all each person does is select their name, and then the pay period from single-selection drop downs, and then enter the total hours worked?

3 Replies 3

Yes. Make the primary field a Formula-type field. Taking a stab in the dark, your formula may look like this:

{Pay Period} & ': ' & {Name} & ' (' & {Hours} & ' hours)'

Thank you! Unless I’m missing something, wouldn’t “formula” be a computed field that isn’t an option for primary fields?

Primary fields can most certainly be computed fields. I would argue in a lot of instances it makes more sense to have a computed field for the primary field than a non-computed field.

There are some field types which aren’t allowed for primary fields, but formulas are not one of them.