โ ็พ็ถ
ๅใฎ็จฎ้ก๏ผๅ็ ง
ๆจๅฅจๅค๏ผORDERBY( select(City_Table[id_City],[country_name]=[_thisrow].[country_name]), [id_City],false)
ๅ็ งใใใๅคใฏใไปฎๆณๅใฎ [City_name] ใจใใฆไฝฟ็จใใใพใใ
โ ใใใชใใจใใใใ
ๅใฎ็จฎ้ก๏ผใใญในใ
ๅธๆใฎๅค๏ผCity_Table[City_name]
ๆกไปถ๏ผ[ๅฝๅ]=[_thisrow].[ๅฝๅ]
ไธฆในๆฟใ๏ผ้ฝๅธ_ใใผใใซ[id_้ฝๅธ]
็ฟป่จณใฝใใใไฝฟใฃใฆ่ณชๅใๆฅๆฌ่ชใใ่ฑ่ชใซ็ฟป่จณใใฆใใใฎใงใใใใซใใใฃใใใใใใชใใใ
ใๅๅใใใใจใใใใใพใใ
Translated to english:
Current status
Column type: Reference
Recommended value: ORDERBY( select(City_Table[id_City],[country_name]=[_thisrow].[country_name]), [id_City],false)
The referenced value will be used as the virtual column [City_name].
โ I want to do something like this
Column type: Text
Desired value: City_Table[City_name]
Condition: [Country name]=[_thisrow].[Country name]
Sort by: city_table[id_city]
Is your intention to get a list of City Names sorted by [id_City] and filtered by country?
The next question is where do you intend to use this list? If it is just as dropdown choices then you likely have everything needed. If you need to display that list somewhere else, then you may need to add additional columns depending on where that is.
Thank you for contacting us.
Is your intention to get a list of City Names sorted by [id_City] and filtered by country?
โThat's right.
The next question is where do you intend to use this list?
โI would like to use it for a simple customer list.
ใThis is to simplify input.
ใIf I use "ref", it will be difficult to see the relationship, so I thought it would be better not to use "ref".
Thank you for your support.
User | Count |
---|---|
43 | |
29 | |
29 | |
14 | |
14 |