Hi,
I have:
When clicking into Detail view for a job from the Active job view, Iโd like to have an Action button which opens a view made from a slice of the Previous Jobs table filtered by some job details of the job Iโm in Detail view for (or in other words a history of jobs at the currently selected location).
I have an action and โprominentโ button set up which links to a sliced view. The only missing part is how to create the view. So for the detail view Iโm in, the slice view should show all previous jobs based on that address.
Iโve been playing around with [First Name] = [_THISROW].[First Name] (as a test) but no luck so far.
Any thoughts? I assume this is a common use case.
Solved! Go to Solution.
Thank you for the details. You are correct. AppSheet presents many powerful possibilities in terms of business apps.
If I have correctly understood your requirement, have you explored use LINKTOFILTEREDVIEW() action?
In the sample apps below, there are examples of LINKTOFILTEREDVIEW() action usage.
You may wish to share what expression you are currently using and where you are using to go the desired view of previous jobs.
Hi Suvrutt, Thank you for response. I suppose my question was a bit long-winded.
What I need is to be able to make a View based off of a slice where the sliceโs row filter is based on values in the current record. โCurrentโ as in the row for the Details Iโm in.
So in terms of usage, Iโm in the Details view for a job. One field is โStreetโ. I click on an Action button and go to a View which has a table of all jobs from the other (Previous Jobs) table for that address, i.e. a history of our work at that address.
I thought that having a slice with a row filter of [Street] = [_THISROW].[Street] would work but I may be misunderstanding how to _THISROW works.
I hope thatโs clear and thank you or anyone else who can help out. This is honestly quite exciting and I guess/hope itโs another case of โsimple when you know howโ.
And thank you for your patience. Iโm just half of a husband and wife cleaning business and Iโve already put Appsheets to great use with simple stuff so far. Really loving the potential and eager to learn the โhowโ.
Thank you for the details. You are correct. AppSheet presents many powerful possibilities in terms of business apps.
If I have correctly understood your requirement, have you explored use LINKTOFILTEREDVIEW() action?
In the sample apps below, there are examples of LINKTOFILTEREDVIEW() action usage.
Oh man, thank you from the bottom of my heart! Thatโs exactly what I was after and works like a dream. Each step with AppScript makes me a little more productive and less laptop-bound for admin. Lovโn it.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
18 |