I am tasked to show all active rows from a sheet in a Smartsheet form where users can select which one they want to de-activate and provide business reasons and justifications.
1) You would need to set up a Data Shuttle workflow to export the column containing the Row ID as an excel doc. You would want to include a filter in the workflow to only pull rows that are active. Then you would need to set up a second Data Shuttle workflow to update the dropdown values in the column where the user can select the Row ID they want to deactivate.
2)您可以使用动态视图。
3) You can use a report to show only rows that are active and drop that onto a dashboard alongside a form that allows free text for the Row ID they want to deactivate.
1) You would need to set up a Data Shuttle workflow to export the column containing the Row ID as an excel doc. You would want to include a filter in the workflow to only pull rows that are active. Then you would need to set up a second Data Shuttle workflow to update the dropdown values in the column where the user can select the Row ID they want to deactivate.
2)您可以使用动态视图。
3) You can use a report to show only rows that are active and drop that onto a dashboard alongside a form that allows free text for the Row ID they want to deactivate.
I have used Data Shuttle and Reports/Dashboard, but not Dynamic Views. Based on your options, it seems I'm leaning towards either Dynamic Views or the Dashboard. Just a couple of questions:
Which one is better for a user point of view - the Dynamic View or Dashboard? (Sorry, I have not seen or used Dynamic Views) For a builder point of view, specially for someone who has not done Dynamic Views?
If we opt for the Dashboard, is there a way to include a Form on a Dashboard?
We want to update the sheet with the active rows as well to show de-activation after the whole exercise. Is this easier to do on Dynamic Views or the Form on the Dashboard (Data Mesh possibly to use here)?