Error Msg Creating Single Record Update

[reyemmaus]

Please help with following error when creating a Single Record Update Form

 

"Your datapage must be authenticated or you must pass an identifying unique ID as a parameter. To update the record based on a unique ID parameter, be sure you have enabled Advanced Options and Parameters. "

 

I have checked Advanced Options and Parameters boxes but I still get this message.

 

 

 

Rey

[Jan]

Hello Rey,

 

your data source should contain a unique field.

When a user wants to update an item, he should be able to find it by a unique parameter, usually it is ID.

[reyemmaus]

Thank you! I was able to move forward; however, when I clicked Finished, it asked me to fill in the Parameters field.

 

What do I put there?  I have 5699 records.  I tried 1-5699.  I tried just entering 5700.

 

I kept getting "No records found."

[reyemmaus]

Caspio Ninja,

 

What do I fill in for parameters field?

[MayMusic]

What unique field did you select to pull up the records with? Open the table get one of the values of that unique field and use that to pull up the record.

[MayMusic]

This tutorial might help http://howto.caspio.com/datapages/forms/update-forms/

[casGary]

Note that "Single record update" is the kind of datapage dedicated to update information in only one line of your table. So system needs to figure out which record you want to change. That's why it requires eather parameter or an authentication and that is why it requires a unique field for each record. 

[reyemmaus]

Tech support said only to use Single Record Update in certain special circumstances but rather just use the Search and Report, so that is now working for me. Thanks All!