LinkedIn
Twitter
Dear Friends,
I have a requirement. Below you can see a drop down which possess list of ref values ( Courier Company Names ) from Table Courier (Key column - Courier Name ).
We will enter the shipment details such as Parcel weight, dimensions, delivery location etc. in Other fields in the form. According to that each courier company has its own tariff. For understanding purpose and finding the cheap tariff . Is it possible to bring the dropdown with the price details as expected below. This help us to book parcels based on lowest price.
Note : Prices varies according the predefined tariffs in the database and distance, Air or Surface etc. For all these will be calculated by using expression separately.
Reference for Input fields :
Thank you.
Should I add a virtual column in the parent table ?
Parent table has the predefined values like cost, tariffs etc for each courier company.
Predefined values are pulled from the parent table called COURIER it is used for the calculation purposes.
My requirement is based on the calculation ( Weight x Cost ) done in the child table. Calculations are not done in the parent table courier. Then how virtual column as label helps here ?
One easier option I would try is to have the Courier Name reference column in the child table form as an Enum with base type as reference and the column to have input mode as button. Then after selecting all the parameters such as weight distance, mode, the user can easily compare the charges for different couriers by selecting the respective courier name.
Also I would try to order the courier names in the order of their per distance charges. So the cheapest appears at the start and costliest at the end in [Courier Name] selection. This may not work 100% because some couriers may charge for different parameters such as distance , mode and weight. But one can definitely create a ball park order for the user to select from cheapest to costliest.
Also the courier name list can be possibly filtered in / out based on selection of weight, mode and distance etc. For example, some may not be offering air or longer distances and so on.
Of course , one can think of still more ingenious ways as well.
another expectation:
A button can be included near the Courier Name Field in the form . that button takes to the new view where the parcel information size, weight etc are displayed and final calculated prices of each courier companies are display in the buttons / box. If the buttons pressed then particular courier name is entered in the courier name in the form . I could express my needs and expectations but I don't know how to do it.
@Suvrutt_Gurjar wrote:Also I would try to order the courier names in the order of their per distance charges. So the cheapest appears at the start and costliest at the end in [Courier Name] selection. This may not work 100% because some couriers may charge for different parameters such as distance , mode and weight. But one can definitely create a ball park order for the user to select from cheapest to costliest.
How to arrange courier names according their cost ?
------------------------------------------------------------------------------------
My Expectation:
If I have 10 to 20 + courier companies. button method may look congested. So I prefer dropdown and you have give the new idea of sorting based on charges. Kindly share the logic for it. I try to implement here.
Note : I wish put the final calculated charges or amount in dropdown or buttons not the cost/kg.
I don't how to put the child table row calculations in the dropdown. Please help @Suvrutt_Gurjar
I am afraid you will need to develop based on suggestions as these are broad suggestions.
For example , in the test app I made to share suggestion for your this post's requirement, the Courier charges are as follows
So the [Courier_Name] ref column in the child table will have a valid if of
IFS([Mode]="Surface",
ORDERBY(Courier_Company[ID], [Rate_Surface], FALSE),
[Mode]="Air"
ORDERBY(Courier_Company[ID], [Rate_Air], FALSE)
)
This will sort the Courier_Name buttons with respective rates in ascending order. Of course this sorting is by input rate cost. Generally overall price will be proportional to the rate, is it not? If other parameters are same?
Also as mentioned, all companies may not be providing all services. Some may not be providing "Air" service/ So if "Surface" mode is selected, you can remove those companies from the available reference values.
In that case your valid_if expression could be
IFS([Mode]="Surface",
ORDERBY(SELECT(Courier_Company[ID], ISNOTBLANK([Rate_Surface])), [Rate_Surface], FALSE),
[Mode]="Air",
ORDERBY(SELECT(Courier_Company[ID], ISNOTBLANK([Rate_Air])), [Rate_Air], FALSE)
)
You can implement the above with a dropdown also but there will be additional clicks of the mouse to select a value from dropdown.
You will of course need a little plug( or configure 🙂) and play to arrive at the best possible option.
