AppGini Community Forums

Hi everyone - I'm new so hello!
I'm setting a field called Group to one of the default options: <%%creatorGroup%%>
I have another field in the same table - Country - which I want to auto populate with a choice that depends on what goes in the Group field.
In other words, say the <%%creatorGroup%%> throws up 'UK Editor' in the Group field, I want the Country field to say 'UK'
If the <%%creatorGroup%%> throws up 'France Editor' in the Group field, I want the Country field to say 'France'. And so on.
Can anyone help with how to do this?
Thanks in advance.

Hi,

you could use the after_insert hook for that. Update the just inserted record according to your logic for the Group field.

It depends where you want to hold your mapping fo UK Editor -> UK, France Editor -> France , etc.
Either create a separate table for that (so you can retrieve the matching entry), or if is always the first word of the group, you could use PHP to extract the necessary information and insert accordingly

Thank you.
I have a table 'meetings' with a field 'group' <%%creatorGroup%%> and a field 'insert_field'. (I'm trying to autopopulate 'insert-field' with something depending on what's entered in 'group'.) I created a table 'country' with two fields - 'group' (UK Editor) and 'show' (UK)
Then went to the after_insert hook area in the hooks/meetings.php. And I'm trying to put a SQL statement in their but can't seem to get it right. I tried lots but for example ..
INSERT INTO meetings.insert_field
SELECT show FROM country
WHERE group=meetings.group;
Am I at least on the right track?
Thanks.

Hi,

yes you are, you should add the selected row in your statement.
Something like

WHERE group=meetings.group and id=$data['id']

assuming your PK is id.