How to design this XCP application

Hi Experts

We have a requirement to replace a manual process which is currently performing using Excel sheet . At present the excel sheet gets the manual signatures from various users. I need to automate this using XCP forms builder , Process builder and taskspace

The excel sheet looks like below . It needs 200 rows

Number	Name	Designation	Price	Number	Project Name
1
2
3
4
--
--
200

I need to convert this excel sheet with 200 rows to a form . I need the ability to do calculation in column to see the total price. and if possible hide a column according to user roles

Can you please throw some hints or ideas to design this application ?

Find more posts tagged with

Comments

AlanZ

Your question has been moved to the Documentum developer community, where it has a better chance of being seen and answered

Haroon_A

There's a good xCP tutorial on ECN, which gives you a good idea of where to start. For the calculation, you could use xPATH calculation formula to calculate your total price, and you can hide/show columns based on roles in forms builder.

shreeharinair

Thanks Ahmad,

Do you think it is a good idea to put 200 text boxes in a tabular form and go with XPath ?

Can you send me the link to the tutorial ?

Haroon_A

putting 200 text fields in one form is really not a good design. To how many people do you need to send this form? if it's limited number, let's say 8 or 10 people, taking care of some 10 or 15 rows, then you could create forms with those rows only for each user (group of users).