Query in Dependent Fields

[bocanhcam]

In my Order resource. I have a customer_email field like this:

Text::make(__('Customer email'),'customer_email')
                ->required()
                ->rules(['required', 'email:rfc,dns', 'max:50'])
                ->placeholder(__('Placeholder string limit 50'))
                ->onlyOnForms(),

When changing the input of the customer_email field. I will need to query DB to get members.email and then fill in other fields depending on it. For example:

Text::make(__('Organization name'),'organization_name')
                ->rules(['nullable', 'max:50'])
                ->placeholder(__('Placeholder string limit 50'))
                ->dependsOn(['customer_email'], function (Text $field, NovaRequest $request, FormData $formData) {
                    if ($formData->customer_email) {
                        $member = (new MemberRepository())->findByEmail($formData->customer_email);
                        if ($member){
                            $field->setValue($member->organization_name);
                        }
                    }
                })
                ->onlyOnForms(),

The problem is I have a lot of fields like this. So this will create a duplicate query to do one thing get $member.

Is there any way to do it properly?