Field with ChildFold Business Rule causes issues in export

Version 1

    Details

    After exporting a record that contains a ChildFold business rule, exported files do not open. The rule otherwise works as expected.

    • An excel file gives the error: "Excel cannot open the file because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."
    • A .xml file gives the error: "Unhandled exception: Function ChildFold is not supported in a database query."
    One possible resolution to this problem is listed below.

     


    Resolution

    The field type that the ChildFold business rule is on must be a text field in order to be exported. Number fields will calculate correctly, but will not export correctly. Re-create the field as a text field and remove the number field from the Form and List.