Can you use a slice in a Start Expression?
I have the followingโฆ
This one worksโฆ
straight to the Students table
<<Start: OrderBy(SELECT (Students[Name], [Type of Student]=โFighterโ), [Name])>>
This one does NOT workโฆ
going to the Active Students slice.
<<Start: OrderBy(SELECT (Active Students[Name], [Type of Student]=โFighterโ), [Name])>>
Iโm confusedโฆ
Your current Select does look wrong. It is missing the condition. Try changing it to include a condition. I used โTrueโ in the following one.
OrderBy(SELECT (Active Students[Name], true), [Name])
Earlier you specified the following, and it had a condition.
<<Start: OrderBy(SELECT (Active Students[Name], [Type of Student]=โFighterโ), [Name])>>
Both Start expressions look correct. What error are you seeing?
@Philip_Garrett_Appsh the second wonโt work.
Its a slice but for what ever reason wonโt return anything.
Okโฆ for some reason I thought the condition was optional .
That did the trick!
Way to go Philipโฆ
Really helpfulโฆ
Thank You.
Glad to hear that it is working. I am really impressed with how much you have done!
Iโm a quick studyโฆ and I really love this platformโฆ Iโm building this particular app for one of my trainersโฆ Iโm only building it to get better at AppSheetsโฆ
Thanks again sirโฆ
I really appreciate youโฆ
Great post!
I like the scope of this app, would be very useful in any school to keep better track of the trouble-makers and nip it in the bud!
You should actually be able to build in some formulas and features that would help automate the response, mitigation and even rehabilitation of these troubled kids. Ex. If you add a โFollow upโ system to log historical data, even Family data, you would eventually have an amazing tool that could predict/list problems and solutions of new cases that might otherwise be overlooked in the middle of such turmoil.
Imagine entering the details of this mornings fight into your app, all official notifications are sent out, and the school Counselors get a report suggesting that little Jimmy Peters is 1. very likely not getting proper morning nutrition and 2. very likely allowed to stay up until midnight 6 days per week! I would also think that automated preliminary reports like this, based on historical data, might make it easier to get parents to buy in to Counselor recommendations.
@Stephen_Mattison Im not sure thats the intent of this app actuallyโฆ however, what your suggesting might actually be very helpfulโฆ
The premise behind my app is this:
You are an instructor (fitness and Martial Arts in this case) that moves between facilities and needs to track students in multiple classes at multiple locations. Broadcast messages and reminders to a specific individual, class, or facility and the ability to pull payment, status, and progress reports.
Iโm currently building this application simply as a way to learn AppSheets better. One of my fighting trainers is being my Use Case.
Ha!
Silly me!
I was thinking Fighter, Biter, Cryer, Pukerโฆ
Great job getting into AS, looks like youโve got a great start and very useful app!
LOTS you will be able to do for your niche, and Iโm sure youโll find lots more niches to explore!
@David_Hopkins I bet the Start expression is fine.
I would trouble shoot the slice.
When you go to the Slice and click โViewโ are you seeing the data you expect? Somehow you are filtering out too much of the data.
I use the slice to feed the main entry of the app.
Sup Iโm supposing that its working correctly
Can you clarify what you mean when you says it wonโt return anything? Are you get an email with an empty body or you are not getting an email at all?
If you are not getting any email at all, then you should check Audit History.
I just checked the slice directly in the View Data window and itโs good.
When I set the start to โActive Studentsโ the email just never comes.
So I just ran the test again and found thisโฆ
โOrderBy(SELECT (Active Students[Name]), [Name])โ is invalid due to: SELECT has invalid inputs. Error: Workflow rule โActive Students Reportโ Start expression โOrderBy(SELECT (Active Students[Name]), [Name])โ should generate a List of Ref values.
I think Im getting closerโฆ
@Philip_Garrett_Appsh The only difference i can see in the test data for the report is the name of the Table calledโฆ
either โActive Studentsโ or โStudentsโ โฆ one works, one does not.
Im not sure what โinvalid inputsโ the error would be referring to .
@Philip_Garrett_Appsh BTWโฆ
Thank You for your help Philipโฆ itโs much appreciatedโฆ
Can you tell me the workflow rule name and the steps to repro?
Certainlyโฆ
Workflow is โActive Students Reportโ.
Itโs called from the Menu item โReportsโ then โActive Student Reportโ and โGenerateโ icon.
You can also check out the Active Fighter Reportโฆ they are the same in all ways except Active Fighter sets [Type of Student]=โFighterโ in the SELECT statement.
User | Count |
---|---|
35 | |
34 | |
27 | |
23 | |
18 |