How to sort a Ref to a Slice?

AppSheet AppSheet Q&A
,
1

I have a list of jobs in a Google Sheet that is used by two apps as a Ref for a drop-down list of options. Each app references a Slice of the jobs sheet that is relevant to that app. Staff use a third app to add new jobs to the list, to make sure everything is formatted right, but because AppSheet always adds new rows at the bottom, the added jobs aren’t in any useful order (e.g. numerical by job number), which makes the drop-down Ref lists hard to use.

How can I sort the job sheet rows, either in the Slice or in the Ref? I tried putting a ORDERBY command in the VALIDIF for the Ref, but that made it list all the jobs in the sheet, not just the ones in the Slice anymore.

2

EJ_Mann:

I tried putting a ORDERBY command in the VALIDIF for the Ref, but that made it list all the jobs in the sheet, not just the ones in the Slice anymore.

Maybe you use your table name instead of slice name.
Anyway, post a screenshoot

5 Likes
3

Nope, still using the slice. Screenshots:

3X_3_f_3fe89fd1f0c938d0635a89e922b9ddaaeff70ef0.png
3X_3_f_3fe89fd1f0c938d0635a89e922b9ddaaeff70ef0.png775×620 36.2 KB

3X_1_f_1f3f15eb3a4e90b7645d2cc1872307194785bb11.png
3X_1_f_1f3f15eb3a4e90b7645d2cc1872307194785bb11.png767×606 29 KB

And the relevant Slice:

3X_b_0_b0aa500386b3cfaf031ece9e07fb4286950357da.png
3X_b_0_b0aa500386b3cfaf031ece9e07fb4286950357da.png824×598 36.4 KB

1 Like
4

Never mind, I found a solution: replaced ORDERBY(job_code[job_code], [job], FALSE) with ORDERBY(FILTER(“Job Filter”, TRUE), [job], FALSE) (where Job Filter is the name of the Slice). Seems to do exactly what I needed!

1 Like
5

EJ_Mann:

ORDERBY(job_code[job_code], [job], FALSE)

ORDERBY(
  JOB FILTER[JOB_CODE], /*HERE IS WHERE YOU MENTIONED THE TABLE INSTEAD OF THE SLICE*/
  [JOB],
  FALSE
)
1 Like
6

SkrOYC:

EJ_Mann:> > > ORDERBY(job_code[job_code], [job], FALSE)> > JOB FILTER[JOB_CODE], /HERE IS WHERE YOU MENTIONED THE TABLE INSTEAD OF THE SLICE/

Oh sweet, that’s even easier. I didn’t know you could use a slice as the data source for ORDERBY. Thanks!

1 Like
7

Sure!
Any Table[Column] expression can be written as Slice[Column]
That’s why I think @Steve uses "Dataset" to refer to it

2 Likes