Why is there a change?
In the early release of document tables the state of the document extraction was exposed as application visible data in the application schema. In particular there were columns for IsEdited, NeedsAttention, StatusCode and AttentionDetails. This coupled the business logic of the document content with the processing state details. It was decided this was not desired.
What has changed?
With the latest release, the status data is not available in the AppSheet tables. In addition, only documents that are considered finalized will be available in your application. If you have previously created tables with the previous release of document support, these applications will continue to work with a few caveats:
- All columns that contained state information will no longer return data to your application.
- All documents still in a not-final state will no longer appear in your application
- Any application logic that depended on the state columns will not function properly (e.g. slices, automation, etc)
Instead, a new mechanism has been introduced to manage the not-final extractions. These will be logged to your application’s audit log, and those logs will contain links to help you resolve the issues (in this initial release, the resolution will need to occur in Sheets directly).
How do I align my old application with the new solution?
To bring your application into alignment with the future state of this feature, you have to take two actions:
- Remove all dependencies on the state schema fields (e.g. slices, automations, etc).
- Remove the schema fields from your table.
Once those two things have been completed, your application will have the same behavior and structure as if it were built with the updated release of this feature. As always, if you encounter unexpected issues with this migration, please reach out to AppSheet support.