I wonder is there a way to get data with SQL request and fill specific newform.aspx columns with data from request?
For example, a new list item is opened, then user inputs for example Name and clicks a button or similar to execute SQL request which populates from columns, for example Department and Phone. And then user fills in other columns and saves the new list item.
I guess this could be done with SharePoint External List, but this would need to synchonize the External List with the connected database every night automatically.
Maybe there is some other ways to make this work?
All the best,