Hello
I am a new user to this forum. I just started a new job and they are using Apex for their front end solution. I have lots of pl/sql experience and a fair amount of Oracle Forms\Reports (4.5) experience but am totally new to Apex. So sorry if this is a basic question or one that has been answered before but am looking for some general advice\direction
We have a new requirement to allow users to define "custom" forms - meaning there will be some basic columns that relate to current tables. But they also need to be able to add additional columns to the base query. These would be columns that do not exist in any table but would be stored in a custom_form table that basically has column_id, display_name, type. The value (stored as varchar) for the column would be stored in another table that would have a foreign key back to the custom_column table and another foreign key to the main data table.
So what I basically need to do is to send up a dynamic collection (variable number of columns) to Apex and have Apex display the collection and then to have Apex send the collection back so we can update\insert the changed data. I think Apex can do that, just not sure if they can handle a dynamic number of columns being sent up to them. As stated in the title this would need to be a multi-row\tablular form.
We would like the columns in Apex to be aware of the underlying type of the custom columns if that is possible (dates, numbers, etc)
Not sure if the collection route is the best way to proceed or if there is another way to accomplish this requirement. Any advice or basic examples would be greatly appreciated!
TIA!