there is not "uniq" function, but, yes, you can combine two fields as either calculation or an Auto Enter feature and you can set the validation to require uniqueness. These features are unrelated to whether it is web published or in the application mode. There may be issues if one of the fields are blank or if both are blank or somehow not unique, if that is a requirement. It could be that you are entering these two fields in web mode and have not committed or refreshed the record, thereby not updating the auto-enter or calcualtion field to show the two fields combined. They do update on the screen right away in the application mode, but remember that web application are http calls which mean they are not persistent for updates like the regular FM client application.
Give us some more information or upload a sample of you still can't figure this out.
Acording my efforts(layout>trigger->onrecordcommit, field->calculated value) all this ability just for application mode. How I can create composite key for web, is it possible? Can you give me solution for web?
trigger based solution for composite field uniqf=nam & " " & name_role
look my file http://zalil.ru/34066371
Best regards, German
Script Triggers don't work in IWP. HTTP web connections are not persistent, so there is no way to make them work. It is an architectural problem. Make it an auto enter solution so that when the record is committed, it will combine the two fields into the new combined unique field.
Can you give me more information about auto enter solution. some example or link?
Yes, go up to FILE and pull down to MANAGE and select DATABASES. Select the table you are working on and selec the field that you want to store the combined data. Cick the options button (or just double click on the field) and up will come a menu. The top left tab is the Auto Enter tab. In the auto enter tab, go down and select the checkbox by the calculation section and the calculation engine should pop up. Put the formula in there combining the two fields and click OK. That should take care of it! Let me know if you have any difficulties and best of luck!
Above you told me that you used a script trigger to make a calculation in IWP. That will not work. You have to do an Auto Enter caclulation that willl not happen until you commit the record in IWP.
Your only other choice is to have a script that creates a new record and the script commits the record or does the calculation and then goes to the next field. Just create a New Record button to do this.