Hello Friends,
Please suggest your best approach for Lotus Notes To SharePoint 2013 Migration !!!
Thanks,
Ashutosh
Not hyphens – just hide-whens, the programming you can put on fields in Notes to hide or show them automatically under certain conditions. For example, only show a field to capture “Zip Code” if the user has chosen “USA” as the country, or only show a field for “Comments” if the user answers “Yes” to a question asking if they have any feedback. Notes makes it ridiculously easy to manage these, and same with the data validation that goes along with them. (That is to say, don’t make a field require a value if the user can’t see it to enter anything.) SP doesn’t have a code-free way to do this, so in some projects we’ve used JQuery to query the contents of fields and run front-end code to show/hide rows accordingly and in other projects we’ve written custom web parts.
SP does have native data validation, but in the JQuery cases you actually don’t want it to, because if you tell SP a field is required, it is required at all times whether the user can see it to enter data or not. In those cases we used JQuery again to do the validation on fields that might or might not be visible to users, since SP didn’t have awareness of it.
We only used Powershell for data migration, not JQuery, sorry if that was confusing. Powershell for the back-end work, and JQuery for the front-end.
Notes workflows are powerful indeed, and easy to set up with fairly complicated schedules. I’m glad you’ve found some tools to help!