
Hi,
I have a requirement that when a case is created in the Customer Service hub and a postcode is entered that this will look up values in 2 entities.
Postcodes entity - holds the postcode, LA and Region
Growth Hub postcodes entity - holds the Postcode and Growth Hub
These need to be 2 separate entities as there is 1 row per postcode in the Postcodes entity but there could be multiple rows in the Growth Hub Postcodes as 1 postcode can belong to more than 1 Growth Hub.
On the Interactive Case Form I have added 2 sub grids with the above views in and they are searchable. But instead of manually searching in each sub grid I want it to automatically suggest LA/Region and Growth Hub based on the postcode.
Is this possible? If it is possible with Javascript could someone help me out as can adapt javascript but not particulary good at creating it :(
Debra
I don't know if possible in subgrid but you can attach an onChange Event to a field that do a fetch with the postcode you enter. Then, if there any result, you put the result in the new field (LA/region). About the subgrid i can't help more, i haven't worked on them much enough