Child pages
  • Using TableView merger to find duplicate records

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

This is the documentation for ConfiForms Server/Data Center app

However, this might also work for ConfiForms cloud and in most cases it does. But please see this page to understand the differences between server and cloud versions of the ConfiForms app.

Consider having a requirement to find duplicate records in the ConfiForms dataset.

Below you can see the approach to use to complete the task.

For clarity we will have a simple form with just 2 fields

Field "myname" of type text and the field "mark" - a dropdown with choices from 0 to 5

<ac:structured-macro ac:macro-id="d15cdea6-43a1-4555-aa1d-ee3879e2bdbe" ac:name="confiform" ac:schema-version="1">
  <ac:parameter ac:name="formName">f</ac:parameter>
  <ac:rich-text-body>
    <ac:structured-macro ac:macro-id="bad2c384-a4ab-47ce-9207-28ee30111017" ac:name="confiform-entry-register"
                         ac:schema-version="1">
      <ac:rich-text-body>
        <p>&nbsp;</p>
      </ac:rich-text-body>
    </ac:structured-macro>
    <p>
      <ac:structured-macro ac:macro-id="8b34ab65-e56a-4550-89a8-99d0278e4952" ac:name="confiform-field-definition"
                           ac:schema-version="1">
        <ac:parameter ac:name="fieldName">myname</ac:parameter>
        <ac:parameter ac:name="fieldLabel">The name</ac:parameter>
        <ac:parameter ac:name="type">text</ac:parameter>
      </ac:structured-macro>
    </p>
    <p>
      <ac:structured-macro ac:macro-id="45dd0575-4e4f-4f03-9757-4ef10d301aa8" ac:name="confiform-field-definition"
                           ac:schema-version="1">
        <ac:parameter ac:name="fieldName">mark</ac:parameter>
        <ac:parameter ac:name="fieldLabel">Mark</ac:parameter>
        <ac:parameter ac:name="values">false[0=0|1=1|2=2|3=3|4=4|5=5|]</ac:parameter>
        <ac:parameter ac:name="type">select</ac:parameter>
      </ac:structured-macro>
    </p>
  </ac:rich-text-body>
</ac:structured-macro>
  • No labels