Adding new records to custom table

Justin W · ‎04-20-2022

Hello,

I am reaching out because I was wondering how to add a new record to a custom table? Most of the time I don't have to build/update custom tables.

So for example, there is a custom table that has been created that will contain a list of approvers. How would I add a new user to that table (note: The approver already exists and has a user profile).

Any help would be greatly appreciated!

Thanks!

dmathur09 · ‎04-20-2022

Hi Justin,

It seems you have not added any field in the table. You can open the form and right click on banner and click on Form Design.

Add the relevant fields and save. Once you have the form you can provide all the details and save the form.

In case you are unable to find the module to the custom table. You can type in your custom table backend name and end it with .do. For eg custom_table.do.

Hope this helps.

Regards,

Deepankar Mathur

View solution in original post

RKerr · ‎04-20-2022

Assuming you list of approvers references sys_user, you would simply need to determine the 'filter' that is defining your current approvers, and update the new user to meet that criteria.

Hope that made sense...

Justin W · ‎04-20-2022

Thank you for your quick response!