Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
7 subscribers
Views
1841 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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?...
OriginalPostID-111888
OriginalPostID-111888
Discussion posts and replies are publicly visible
Parents
0
Jason Ruvinsky
Certified Lead 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 Lead 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