How do I enter data into an existing row using a form?
How do I meet the following requirements?
Using Request Tracker with Form Template -
End user opens change request form - enters initial information related to the change being made.
This begins a new record (row) which consists of the initial information provided through the form plus pre-defined "phases" . Turn-around-times for each phase are tracked across the row in order to collect TAT for each step in the process.
At each phase, the end user can select the appropriate form and enter the unique ID number (from a dropdown generated by the system - link to ID field). Form auto populates a few pieces of information so the end user can verify they have selected the correct ID.
User enters a few fields to add data to the existing record (row).
Please advise.
Answers
-
Hi Alicia,
The easiest way to accomplish what you're describing would actually be through the Premium Application, Dynamic View. Please see our Help Center article on Dynamic View for more information.
If Dynamic View isn't an option for you, you could potentially set up a system of workflows that send Update Requests (see here). This would send rows to specific people based on certain criteria. This will open up a different type of form that can update that specific row (instead of creating a new row).
In this instance, the user cannot request to update a row; you would need to have some sort of indicator for when to send the form back to them (whether it's a date or a status change, etc).
-
Could you please clarify the comment about using DV to achieve this update? I have a form to capture a set of information which I then need to be available for comment by another party. Is the solution to create two DV reports - one for the original record entry and the other for the evaluation?
-
Hi @22Wordsmith
You can use a Form to submit rows to the underlying sheet. Then either share that sheet with the other collaborators, or yes, create a Dynamic View or put a Report in a Workapp to surface specific rows that were created through the Form.
If you need more help, it would be useful to know more about your process and exactly what you want visible to each party.
Thanks!
Genevieve
-
Thanks Genevieve. I will move forward with Dynamic View. Fortunately, I have some eager testers.
