{ "name":"employee_add", "title":"Add an Employee", "description":"Add an employee", "parameters":[ {"name":"last_name","type":"string"}, {"name":"first_name","type":"string"}, {"name":"title","type":"string"}, {"name":"title_of_courtesy","type":"string"}, {"name":"birth_date","type":"date"},/*Changed from "string" to "date"*/ {"name":"hire_date","type":"date"},/*Changed from "string" to "date"*/ {"name":"address","type":"string"}, {"name":"city","type":"string"}, {"name":"region","type":"string"}, {"name":"postal_code","type":"string"}, {"name":"country","type":"string"}, {"name":"home_phone","type":"string"}, {"name":"extension","type":"string"}, {"name":"notes","type":"string"}, { "display_field":"full_name",/*Changed from "string" to "popup"*/ "definition":"employee_list", "value_field":"employee_id", "type":"popup", "name":"reports_to" } ], "statement":"INSERT INTO employees ( nlast_name, first_name, title, title_of_courtesy, nbirth_date, hire_date, address, city, nregion, postal_code, country, home_phone, nextension, notes, reports_to n) nVALUES ( n/ * last_name=* / $ last_name, n/ * first_name=* / $ first_name, n/ * title=* / $ title, n/ * title_of_courtesy=* / $ title_of_courtesy, n/ * birth_date=* / $ birth_date, n/ * hire_date=* / $ hire_date, n/ * address=* / $ address, n/ * city=* / $ city, n/ * region=* / $ region, n/ * postal_code=* / $ postal_code, n/ * country=* / $ country, n/ * home_phone=* / $ home_phone, n/ * extension=* / $ extension, n/ * notes=* / $ notes, n/ * reports_to=* / $ reports_to n)", "statement_type":"INSERT"}
The end result is that there will be a new control shown which when clicked will open a pop-up:
Read More
GIPHY App Key not set. Please check settings