Button event Form View, Page Source, based on data value

[Thorby]

Hi,
My client is a property maintence company and I have recommended Baserow to manage their jobs (so far so good). I need to create a set of web pages via the the Application Builder to allow their operatives to update each project with their work activity/images,sign-off, etc.

When the operative logs in, I display a summary of their jobs.

I have added a button to the summary which will take the operative to a page containing a form, as the operative must provide specific details about the work they complete.

However, the form (work details) I need to provide the operative varies vastly deneding on the type of job they are completing.

I was hoping to configure the “Go to Job” button to be dynamic, i.e. when clicked, it will open a page based on the value of Category (reportpage_category)

I was thinking I could build a number of Form View, and use the page parameters to determine the data source on a page parameter (i.e. /reportpage/?form=category

Or maybe I can add an iFrame on the target (reportpage) an use javascript, that will fetch the required form view based on category value.

Any thoughts???

Thank you.

[picklepete]

Good morning @Thorby,

I’m glad you’re enjoying the application builder, your application looks great!

Based on what you’ve shared, it sounds like you’re on the right track. A combination of using our path (i.e. /page/{param}/) and querystring parameters (i.e. /page/?x=y) will do it.

Perhaps in the “jobs” database table, you could have a “category” single select / link to table field there? That way, when you list your jobs and configure the “Go to Job” button, the open page action could pass that category as a query string parameter?

Cheers,
Peter Evans

[Thorby]

Thanks Pete,

I did have to create a Page Name column to translate the category onto a readable URL part (remove spaces, apostrophies, etc) using a combination or lower, totext and replace, as the Category has to be readable in the table.

I also renamed my work pages to match the translated categories

building_work_report
pest_control_report
decorating_report

And use the Custom URL in the table event (NOT FORGETTING the FORWARD SLASH BEFORE the url)

Thanks for pointing me in the right direction.