Jump to content
  • 0
NarayanJr

Handling Duplicate Data Table Entries

Question

I am trying to make it so a user cannot submit the same exact information twice.  I have a data page that accepts a, Name, Country, State, and City and is added to a table.  However you can resubmit the same info over and over again filling the table with redundant information.  I thought about setting the table fields to Unique but that doesn't really do what I want.  I need to be able to enter very similar data as different entries, but not allow identical data.  So an entry of,  Remote Diagnostics, USA, New Jersey, and Toms River, can not be entered twice but allow that entry and Remote Diagnostics, USA, Georgia, and Toms River.  What I need is a Unique entry and not just a Unique field.

 

I tried searching for this but was unable to find anything.  If anyone has an answer or can link me to something I missed it would be much appreciated. 

 

Thank You

 

 

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi NarayanJr,

 

In your case, composite unique index, create by four mentioned fields, is right solution, but Caspio don't support unique indexes by default. You can contact with support team and ask about some PS development.  Also if this feature important for you, please post new idea on Caspio IdeaBox

 

If you want know more technical details please see following link Unique Indexes

 

Thanks

Share this post


Link to post
Share on other sites
  • 0
On 12/3/2013 at 7:33 PM, MayMusic said:

It is also good if others vote to the feature 

Looks like this feature is planned.  Wouldn't hurt to vote and nudge this feature along though.  Here's the Idea Box link.  (Hover around blank area if you can't see the link-- I believe the forum CSS is making it appear invisible for some.)

 

http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/5074733-unique-data-table-entries-not-just-unique-fields

 

Share this post


Link to post
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.

Guest
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.

Loading...

×
×
  • Create New...