Hello @mtrebus1 !
Yes, I was about to share this one. You’ll need to replace that array with code that grabs the data from the external database. I’d suggest to store it in the database along with a timestamp to cache it and avoid making a request each time – this may slow your loading times otherwise.
You can also try this snippet:
add_filter( 'forminator_field_single_markup', function( $html, $id, $required, $options ){
$select_id = 'select-1-field';
if ( $select_id != $id ) {
return $html;
}
$doc = new DOMDocument;
$doc->loadHTML( $html );
$field = $doc->getElementById( $select_id );
// The custom fields. Could be imported form a csv file.
$options = array(
'value_one' => 'Content one',
'value_two' => 'Content two',
'value_three' => 'Content three',
);
while ( $field->hasChildNodes() ) {
$field->removeChild( $field->firstChild );
}
if ( ! empty( $options ) ) {
foreach ( $options as $value => $content ) {
$option = $doc->createElement( 'option', $content );
$option->setAttribute( 'value',$value );
$field->appendChild( $option );
}
}
return $doc->saveHTML();
}, 20, 4 );
Similar to the snippet you shared, the $options array should be requested from the external database.
Kind regards,
Pawel
