Community

• 

  Katja Ovcharova

  • February 18, 2016 13:28

  Hello,
  
  1. - You could uncheck the "Show on verification" option in the field properties, General tab. In this case the checkmark group will not appear on the data form (the form where you edit field values on the verification stage). Another variant is to exclude the whole checkmark group from verification at all, or send checkmarks only to group verification (then the user will onlly see separate checkmark images to confirm that they are checked or unchecked), this can be done on the Verification tab of the field properties.
  2. - To be able to answer this question we need to know how exactly you are going to use the DB. Could you please describe in more details how the values from external data sources will be used to fill the checkmark group in your FC document?

  No 0 Yes
• 

  Aleksey Nikitin

  • February 18, 2016 15:27

  Hello laptorkung,
  
  1. Try to disable "Allow empty selection" option on "Data" tab of checkmark group field properties.
  2. Generally, it could be done with a script rule which connects to DB and selects data. However some cases could be treated without connection within script. It depends on the points were asked by Katja.

  No 0 Yes
• 

  laptorkung

  • February 18, 2016 16:06

  Hello,
  
  1. - You could uncheck the "Show on verification" option in the field properties, General tab. In this case the checkmark group will not appear on the data form (the form where you edit field values on the verification stage). Another variant is to exclude the whole checkmark group from verification at all, or send checkmarks only to group verification (then the user will onlly see separate checkmark images to confirm that they are checked or unchecked), this can be done on the Verification tab of the field properties.
  2. - To be able to answer this question we need to know how exactly you are going to use the DB. Could you please describe in more details how the values from external data sources will be used to fill the checkmark group in your FC document?

  
  
  Thank you for your answer.
  
  1. I mean user in verify station can see drop down but i need to hide only multiple selection.for example i have 4 selection and plus multiple selection total selection is 5.i need to display 4 selection except multiple selection.Now I only disable multiple selectionbut will show.
  2.I meaning if I has oracle database i need to select selection from database to display.if find for write script to get value but I don't know about method or flexi function to put data into checkmark group field.

  No 0 Yes
• 

  laptorkung

  • February 18, 2016 16:10

  Hello laptorkung,
  
  1. Try to disable "Allow empty selection" option on "Data" tab of checkmark group field properties.
  2. Generally, it could be done with a script rule which connects to DB and selects data. However some cases could be treated without connection within script. It depends on the points were asked by Katja.

  
  
  Thank you for your answer
  1.I already but I need to hide multiple selection from drop down
  1. I can write Jscritp for select value from database but i don't know how to put value in to checkmark group.

  No 0 Yes
• 

  Aleksey Nikitin

  • February 18, 2016 16:27

  1. Is verified document of the latest document definition version?
  2. You can set Field("CheckmarkName").Value to true or false in script. "CheckmarkName" is name of checkmark within the group, not of the whole group; it is required to use full names in some scripts.

  No 0 Yes
• 

  laptorkung

  • February 19, 2016 02:23

  Hi Aleks, I will check and try to write script by use function as your recommend. Thank you for your recommend.

  No 0 Yes
• 

  laptorkung

  • February 19, 2016 03:50

  Hello everybody
  I has new question about display screen on verification station.
  Event
  If user choose Type 1 in main drop down. All sub drop down except Type one will invisible or read-only.
  Can I do like this ?
  
  Thank you very much.

  • 00e7a94d-9ac7-4690-8acd-a6ba00d7bc79_image-310.png
  • 2a24c317-b9c7-4189-80d8-a6ba00d7bcac_image-311.png
  • 516fbc25-aa34-429b-8ca4-a6ba00d7bcdf_image-312.png

  No 0 Yes
• 

  Aleksey Nikitin

  • February 19, 2016 16:59

  You can create drop-down lists using IField.Suggest method.
  So the script could be as:
  1. get value from checkmark group; call it 'GroupValue'
  2. connect to database
  3. select all values where name is 'GroupValue'; call it 'DBValues'
  4. create drop-down list with IField.Suggest for each item from 'DBValues'; it is supposed to use a text field here.

  No 0 Yes
• 

  laptorkung

  • February 19, 2016 17:20

  
  Hi Aleks thank you for your guide.
  On next working day I will try it and I will tell my result to you.
  
  I am very very newbie about ABBYY.
  Thank you very much.

  No 0 Yes
• 

  laptorkung

  • February 20, 2016 07:01

  You can create drop-down lists using IField.Suggest method.
  So the script could be as:
  1. get value from checkmark group; call it 'GroupValue'
  2. connect to database
  3. select all values where name is 'GroupValue'; call it 'DBValues'
  4. create drop-down list with IField.Suggest for each item from 'DBValues'; it is supposed to use a text field here.

  
  
  Hi I have question.
  
  For get value from database. Where I write a script? Document section rule script? checkmark Group rule script?
  
  another one Normally Checkmark group has 2 column display value and export value. This function as your recommend I can export 2 column into checkmark group.
  
  For example in database
  TABLE TYPE
  type | values
  Type1 | AAA
  Type2 | BBB
  
  Can I put value in to checkmark group?
  
  Thank you for every answer.
  
  
  

  No 0 Yes
• 

  laptorkung

  • February 21, 2016 05:11

  Can you give me example script?
  I find in google but not has example code.
  
  Thank you .

  No 0 Yes
• 

  Timur

  • March 28, 2016 12:52

  Hello,
  
  You can write this script in document section or check mark group
  
  DB look up script may look like the following(C#):
  
  using System.data.oledb;
  string coonection="your connection string";
  
  OledbConnection Con=new OledbConnection (coonection);
  
  Con.Open();
  
  string Query="your select command";
  
  OledbCommand Command=new OldedbCommand(Query,Con);
  
  OledbDataReader Reader=Command.ExecuteReader();
  
  if Reader.HasRows
  {
  while (Reader.Read())
  {
  //get reader values by accessing its items by index or column name Reader[0] Reade["Column"]
  // populate fields in FC using Suggest method
  
  
  }
  }
  
  
  
  Regards
  Timour
  
  

  No 0 Yes

Please sign in to leave a comment.