How can I use multiple criteria for prefilling a dialog field?

Ask us anything
1

Dear WeWebbers,

The Unit rate in my Jobs dialog should be automatically prefilled with the unit rate of the selected vendor for a specific langage pair, service type…
image

Note I use the pink field for testing different formulas.
I have a view with all relevant fields (see also screenshot): view_v_rates:
SELECT v.v_id,
v.v_name,
vr.v_unit_rate,
vr.minimum_fee,
stp.source_target_iso_codes,
stp.source_target_id,
st.service_type_abbrev,
st.service_type_id,
c1.currency_name,
c1.currency_id,
u.unit_name,
u.unit_id,
v.tenant_id
FROM vendors v
JOIN v_rates vr ON vr.v_id = v.v_id
JOIN source_target_pairs stp ON stp.source_target_id = vr.source_target_id
JOIN service_types st ON st.service_type_id = vr.service_type_id
JOIN currencies c1 ON c1.currency_id = vr.currency_id
JOIN units u ON u.unit_id = vr.unit_id;
How can I use multiple criteria for prefilling the rate (v_id, source_target_id, st.service_type_id)? This formula doesn’t display v_unit_rate, it just lists all rates of this vendor:

image
image479×539 76.2 KB

I cannot use a Filter with Lookup or Map.
image

I know how to achieve this using SQL Select but how can I do it with WeWeb formulas?

2

Hi @BertrandG :wave:

Sorry, I’m having trouble understanding your exact use case.

I’m guessing the filterByKey, lookup, and rollup formulas might be helpful but I’m not 100% sure.

Could you maybe share a video to help us visualize how things are set up on your side and where you’re stuck?

3

Hi Joyce,
You may download the video here:

Just a note regarding the end of my video: I want to filter the vendor rates list by vendor_id (from the Vendor drop-down), source_target_id (from the Source Target Id dropdown; i.e. the source and target language pair), and service_type_id (from the Service Type Id drop-down). The price (rate) from the selected vendor should be automatically entered in the Unit rate field.
I tried the Map, Lookup, and FilterByKey functions but I can’t use more than 1 filter for Lookup and even none for the other formulae.
I hope this makes it clear(er)!

4

Hello,
I’ve found an alternative solution: a table within the dialog. Maybe it’s even better since I can now select from all available vendors using even more criteria. But there’s room for improvement, e.g. the table being displayed in a “floating” window and not fixed inside of the dialog box (taking much space).