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

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?

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)'

1 Like

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.