Automatically Insert a new record

Scriptcase 9 General
#1

Hi Guys,

I have a form, for which I would like to have an automatically add a new record and then once I click the button to take me to the next form.
For example I have

Form_New_Employee

Employee_Number:12345
Employee_Name: Simona

Form_ Address

Employee_Number: 12345
Employee Address:

I’ve created a button to take me from Form_New_Employee to Form_Address, the PHP button is

sc_redir(form_address.php, Employee_Number={Employee_Number});

What macro do I need to include above this button to add New record?

Thanks a million… I appreciate all the support.

#2

Hello, I think the macro you maybe looking for is sc_apl_conf(“my_form”, “start”, “new”); if i have read correctly.

#3

Hi, Thank you for that I have tried it but it is not working…

The problem I am having is 1. Saving the new record and then once that is done, then redirect it to another from where the employee_number field is automatically populated.

#4

sc_apl_conf() Macro is known for having issues. I have had lots of problems with it. Not only that but also sc_redir() sometimes does not work. You might want to send email for NetMake to have them finally fix the HELP file. SC_redir has bugs in examples, syntax etc, so no one really knows what syntax is correct unless you keep trying to see which is working. One place they show comma, then no comma, single quotes, double quotes etc. Macro Help is mess. I requested corrections several times but they do not seem to care. I cannot remember what had fixed my issue right of my head but will post back here if I get this reminded.
It is also important which Events u use foryour macro, I remember that some macros cannot be used in certain Evens - check that.

#5

The macro needs to be used in the master application. It will set the called application in the insert mode. So probabely above the sc_redir. If your global is set correctly (displayed it?) then go to the edit fields section and force the global variable on insert. Remove the key from your form as the value will be forced af inserttime.

#6

Thanks Albert, I am sorry I am truly new to this. What do you mean by firing a global variable on insert? How do you do that? and how to I remove the key rom there form as the value?