Expensive? - ORDERBY(REF_ROWS(), [datetime_column], TRUE)

[Grant_Stead]

How much weight would this add, should I construct it differently?
ORDERBY(REF_ROWS(), [datetime_column], TRUE)

[Steve]

Beware:

Auto-fill parent ref in child from inline table? Questions

After some experimentation, I’ve found that if REF_ROWS() is the entirety of the column’s App formula expression, the Add button in the related inline view will auto-fill the column referenced in the REF_ROWS() expression in the new row. To retain this magic, the REF_ROWS() results cannot be modified in any way, such as by list addition or subtraction, or with SORT() or ORDERBY(). Magic: REF_ROWS(...) (REF_ROWS(...)) Not magic: REF_ROWS(...) + LIST(...) REF_ROWS(...) - LIST(...) SORT(REF_R…

[Grant_Stead]

Gotcha, I usually try and leave it alone because of this…

[wrodriguez1]

So what is a good way to order a REF_ROW? I have multiple dropdowns for employees, zones, locations, departments, positions, etc and they are all in the order added to our database. I would like them in ascending order.

Thanks.

[Marc_Dillon]

wrodriguez:

So what is a good way to order a REF_ROW? I have multiple dropdowns for employees, zones, locations, departments, positions, etc and they are all in the order added to our database. I would like them in ascending order.

This isn’t related to the auto-generated REF_ROWS column.
To change the order of the items in the dropdowns on your Ref-type columns, you should use an ORDERBY expression in valid_if.

help.appsheet.com

ORDERBY()

Sort row references

wrodriguez:

I also would like to be able to pick what is displayed in the dropdown. I have one that is referencing a slice that shows specific things, but the dropdown only shows the key for the table.

It basically shows available vehicles so we can assign one to a request. The dropdown shows the key, which is the VIN. No way to know what kinda vehicle it is.

Assuming these are Ref-type columns, this is a key vs label situation. You just need to change which column in the referenced table is set as the Label.

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

[wrodriguez1]

Marc_Dillon:

This isn’t related to the auto-generated REF_ROWS column.
To change the order of the items in the dropdowns on your Ref-type columns, you should use an ORDERBY expression in valid_if.
https://help.appsheet.com/en/articles/2357312-orderby

Awesome! This worked by using: ORDERBY(Employee[id], [name])
In the Valif If section.

[wrodriguez1]

Marc_Dillon:

Assuming these are Ref-type columns, this is a key vs label situation. You just need to change which column in the referenced table is set as the Label.

https://help.appsheet.com/en/articles/961466-row-labels

Is there any way to display more? Changing the label displays the vehicle now, but since we operate in multiple states, you don’t want to assign a vehicle from another location.

Also… THANK YOU! I appreciate this.

[Marc_Dillon]

wrodriguez:

Is there any way to display more?

Read the article I linked

[wrodriguez1]

HOW I MISSED THAT IS BEYOND ME! LOLLLL

Thank you

[LeventK]

Create a Virtual Column and concatenate the info that you want to show as a label in your dropdown and set this Virtual column as the label for that table. .i.e.
[State]&"-"&[VehicleName]

[wrodriguez1]

Ok cool, thanks @LeventK

[LeventK]

@wrodriguez you’re welcome, it’s my pleasure. Kudos should go to @Marc_Dillon

[wrodriguez1]

@LeventK @Marc_Dillon

Not sure if I missed something.

I crated a virtual column and added the expression below:

I made it the label and made sure nothing else was marked as a label.

The dropdown now only shows the VIN.

Should I be referencing that table instead of a view of that table?

[LeventK]

Can you post a screenshot from your table’s structure please?

[wrodriguez1]

Aw man that would be like 6-7 screenshots. One moment.

[LeventK]

I’m interested only with the table that contains your location and vehicle type/name table.

[wrodriguez1]

Yea that is the main table that holds all of our vehicles.

[wrodriguez1]

This is the column from FleetRequest I am needing the vehicle from VehicleAsset:

This is the slice:

[LeventK]

[Vehicle] virtual column is missing in your slice column setup. As the label column is missing, it’s showing the Key column value only, which is your VIN number.

[wrodriguez1]

LeventK:

[Vehicle] virtual column is missing in your slice column setup. As the label column is missing, it’s showing the Key column value only, which is your VIN number.

This was the final touch.

Much appreciated. You sir are a gentleman and a scholar lol

Thanks

[LeventK]

Glad to hear that your problem is solved. You’re welcome, it’s my pleasure.

[Grant_Stead]

Glad you’re back bud! Missed ya!

[wrodriguez1]

I also would like to be able to pick what is displayed in the dropdown. I have one that is referencing a slice that shows specific things, but the dropdown only shows the key for the table.

It basically shows available vehicles so we can assign one to a request. The dropdown shows the key, which is the VIN. No way to know what kinda vehicle it is.

[wrodriguez1]

Okay it looks like it works if I don’t use the slice. I don’t think the CONCATENATE is passed on through the slice. Maybe I can just use something else to narrow it down instead of the slice.