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.