Multiple fields for unique ID
Allow a combination of fields to be a composite key
In some cases we want a combination of values to be unique. A sample scenario is to ensure that there is one student, attending a particular class on a particular date. This can be achieved if the combination of StudentID, CourseID, and AttendanceDate are designated as key and hence they have to be unique. This is a valid Database concept and it will be great if Caspio implements it.
I understand that the formula field is a work-around, but it is not proper database protocol. Rather than bogging down a table by duplicating data, you should be able to select multiple fields as a combination UniqueID.
![](https://secure.gravatar.com/avatar/37ec9a080f25bbb0acca3bc9ce0db281?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)