It would be nice if you could generally make reference data a little easier to update. A cool feature would be the ability to link a submission response to update reference data.
Here are some examples:
- Having a list of workers and their associated foreman, and being able to submit a move request that updates the reference data so we always know where our workers are.
- Being able to add new projects and project descriptions via a submission.
10
Comments
Please sign in to leave a comment.
There is another request to have Google Sheets integration for reference data. It seems like that request, coupled with Zapier would enable this feature and it would definitely be a welcome one, as changes would be automatically propagated. The downside would be that each of your users would need to have editing rights to the Google Sheets and that would possibly create an issue with staff adjusting other sheets (pricing, most notably). You'd need to weight the good with the bad.
I suppose that you could require a hand-off with the proper approval to change pricing or any more sensitive information.
This is similar to this
https://help.gocanvas.com/hc/en-us/community/posts/360000177468-Update-reference-data-based-on-info-submitted-in-the-form-itself
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!