InfoPath Dev

you would just do whatever logic you needed in your form.  I would probably reject their input and reset the field when a duplicate is detected but you could also pop an alert and use conditional formating to disable submit. If you are using the toolbar submit, I would use validation. You could use an existing field or create one just for ...

Thanks, your View suggestion did work correctly and give me an error message if the Data is duplicated, but it still allows me to Submit the form. is there a way to dissable the submit button if the error message appears?

I agree.  There needs to be a language filter for the site or at least a filter that can be set by the user. Seeing the homepage with all that Japanese gives the user the impression that they are not on the correct homepage and like me ends up spending 10 minutes looking for a button or filter that says "English". ;)  Great ...

Thanks for the reply. I am supposed to finish this project without the use of webservices, will the 2nd view suggestion permit this? or do i need to use webservices?

Welcome to the forum. You would need to query the database with a secondary data connection. I would create a view in SQL that just showed the field you need to check. Then in your form you can have a rule check this data connection if there is a duplicate when data is entered by the user. If you are working with databases a lot you should ...

Welcome to the forum. You would probably need a secondary (mirror) set of data. The user off-line saves their updates into the secondary data source. You could also just add a copy feature to "backup" their changes into this secondary location, that would make the changes to your form pretty minimal..  When you submit for ...

Welcome Tim. This sounds interesting. Do you have a link to the video ypu can post?

Hi, I would like to know how to verify if a certain field already exists in a table before I submit it to a database. I would like to make sure there are no duplicate names. Thanks

Well, I'm going to answer my own question and I feel pretty dumb.  I unchecked the default value box "Update this field....recalculation" and it quit resetting the default value when I opened the field. But it also didn't put in an RC default value for the first expense item in the repeating table.  I had to add a rule ...

Hi all, I have an field ID (sample T123-ABC-DEF-GHI-JKL-CC). How can I get the substring afte the last character "-"? I need the substring "CC". Thank for your help.