Hopefully I can explain this so it makes sense…
I have a Notes form with a multi-value field called Responsible. It gives you a drop down list of names and you can pick more than one.
This form also has a number associated with it.
For the sake of argument, we’ll call it document 1 and you chose Becky, Mary and Sally.
I have a SQL table that I want to put in all the names associated with a document into so it should look like:
DocID | Name
1 | Becky
1 | Mary
1 | Sally
I can get DECS to do a create but updates fail. For example, if I want to remove Sally or add Jim I get ‘Realtime service error: updating external record’.
DECS admin log says ‘Monitor failure – Field count mismatch’
Can DECS do what I want? Any work arounds for this?
Thanks in advance,
Scott
PS: For what its worth, here is my DECS activity:
Monitor Order:
1
Max.Connections:
1
Form Override:
Filter Formula:
Data Integrity:
Allow precision loss and truncation of text (excluding key fields)
Trim Trailing Spaces:
Do not trim spaces on any fields
New Line Delimiter for Connection:
Linefeed and Carriage Return
Data Storage:
Leave all real-time fields in documents
Multi-value data:
Use multi-value data fields
- These options create temporary hidden fields in opened documents
Subkey fields:
Sorting:
Pre-Create Formula:
Stored Procedure:
Pre-Open Formula:
Multi-value data: Use multi-value data fields
- These options create temporary hidden fields in opened documents
Subkey fields:
Sorting:
Missing External Records: Create Record
Key Field Updates: Delete/Insert *
Missing External Records:
Create Record
Key Field Updates:
Delete/Insert *
- These options create temporary hidden fields in opened documents
Scheduling
Scheduling Option: Manual