Question about embedded webform and filtered sheet in confluence
I did some research about the following topic but somehow got stucked and every helping hand is appreciated.
What is the current status:
Currently we are using smartsheet (lets call it "project_overview") to keep track on all our projects. After a few years this list is quite big (around 700 rows) so we are trying to provide our colleagues with a better overview.
We are currently using the "TEAM"-pricing model.
On the other hand we are using massively confluence/jira so our colleagues always have to switch between smartsheet and confluence
What the plan is (see also image attached):
1. We have introduced a web form (in smartsheet) to provide the possibility to submit a project in a very easy way. This form will be embedded in Confluence (via iFrame).
2. The "project_overview" will stay as it is and be something like a database that will contain all new and old projects. The projects submitted by the form will be integrated here.
3. (This is where my problem starts)
Now I want to embed a filtered version of "project_overview" in Confluence (via iFrame) to provide the possibility to see all projects at one glance. Filtered means that I want to show all projects with the status "open", "in progress" and hide all projects with status "done" or "obsolete".
My audience would be smartsheet-users and not smartsheet-users.
To avoid media disruption this filtered embedded sheet should be editable (in Confluence as well as in smartsheet itself) to keep our colleagues the possibility to change status and to see always the newest projects (submitted by the webform).
Is there any workaround to build an architecture like this. I tried with a report but unfortunately an embedded report is not editable.
Is there any possibility to create an architecture like that or am I hunting for an allrounder? Thanks in advance for any help.