From Marcus Wade:
I am constantly in the need of being able to have reference data updated based upon information submitted in the forms. This would be adding rows and updating values in rows. Column manipulation is not so necessary for me at this time but would be a good feature as well.
This is similar to this
Since the reference data is uploaded into GoCanvas as a database, it should be update-able within GoCanvas as submissions occur without the need to utilize other third party apps. In the App, we currently have to select the + to add an item to a field that is not in the reference data, i.e. new customer or product, which would be the trigger to add a new row in the reference data database. To solve for updating existing records, the app could lock fields that are populated from the reference data based on the "Reference Field" and if changes are needed to those fields give the user the option to "Update" the field information or "Create New" that would add an identical row of duplicate data and allow the user to make changes to any of the fields until the record is submitted. The need to review our daily transmissions to identify new records and then data enter that information into the reference data files and then upload that information into the app is significantly impacting productivity savings.
We do have a paid feature called Dynamic Reference data, which gives you the ability to update your Reference Data with information entered in a previous Submission.
This is a feature that is currently available through our Professional Services team. They’ll be able to give you a quote specific to your needs and configuration, but here are some general guidelines:
This is currently through Professional Services but is definitely something we're exploring incorporating into the core of the product. Thanks for the feedback!
Please sign in to leave a comment.
Comments
3 comments