Jump to content
  • 0

Creating automatic increment field



I appreciate Caspio provides a unique number/id field but I am looking to import a database which already has about 1,000 records and all have an internal reference with an alpha prefix and they are then numbered sequentially (i.e. the previous submission + 1) with a maximum of 5 digits as its suffix. Is this possible to replicate in Caspio using Java or whatever or would I have to have the 8 digit (I think none sequential) option already offered in the datapages?

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

I think I have sussed this out - create auto numbering field at table design stage and pass through as a parameter in data submission page so can be appended to a predefined prefix in another field. I have not tested on my database I propose importing which has about 1,000 records already numbered and prefixed so will strip out prefix in Excel, import and hope it will let me use existing numbers if convert it to auto number field? Fingers crossed.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...