I have a form that displays info from a db. I want the form to start empty and then be populated by using the quick search function. I’ve looked at macros but I haven’t found one that does what I want. I noticed the sc_exec_sql but I’m not sure what to query. If I look for nulls it won’t work because the db has no nulls and I obviously can’t insert null records. How do I achieve this? I can use “use title” on a select field to display what I want but that isn’t available for a regular field.
In you onApplicationInit or onScriptInit event you might want to try sc_apl_conf(“name_of_your_form”,“start”,“new”);
Awesome! Thank you very much. It works if put in onApplicationInit.
Actually, this created another problem. When using this macro the quick search bar disappears and I can’t bring in any records now.