i have a master detail relation configured, and wont to calculate a field in the detail records based on property in the master records by calling a stored procedure in sql server/mysql
Welcome!
I’d suggest using either a database view or a custom view to get calculated fields. The custom view doesn’t persist in the database.
Thanks @SamTanner , can you please share more details about the use case to use custom views
the procedure call will use a field from the master table and a field from the details table
In my case I was able to build a SELECT query including a calculated field as a custom view and then build a list page on that custom view.