Hi, We have undertaken a project which aims to replace paper forms. T

senthilar over 10 years ago

Hi,

We have undertaken a project which aims to replace paper forms. There are 6 Account Types in total and each account type has about 15-20 paper forms. So, there are 100+ paper forms in use. We would have to design Appian forms for each of these paper forms. How does the idea of creating a separate CDT for each of these forms sound? This would result in we declaring 100+ variables (1 variable for each CDT) in our top-level process model.
What kind of problems should we expect? Anyone has a better solution to suggest?...

Discussion posts and replies are publicly visible

Parents

0 Jason Ruvinsky
Certified Senior Developer
over 10 years ago

I have a single CDT that stores all form answers (QuestionAnswer), it has an id for the question, and a text field for the answer (no matter what type it is on the form, we're converting to text to store in the database) as well as other metadata. A reference table links the question ids to the question labels. Then I supply an array of this CDT to the SAIL rule for the form, and use rules to append or update the index of each question in the saveInto field, and to get the answer for that question in the value field.

If I have time I'll look into creating a sample application that I can upload to forum, because it's a bit difficult to explain without seeing the example.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Jason Ruvinsky
Certified Senior Developer
over 10 years ago

I have a single CDT that stores all form answers (QuestionAnswer), it has an id for the question, and a text field for the answer (no matter what type it is on the form, we're converting to text to store in the database) as well as other metadata. A reference table links the question ids to the question labels. Then I supply an array of this CDT to the SAIL rule for the form, and use rules to append or update the index of each question in the saveInto field, and to get the answer for that question in the value field.

If I have time I'll look into creating a sample application that I can upload to forum, because it's a bit difficult to explain without seeing the example.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data