I need to build an interface with 100 Editable Columns and all the columns need to be searchable & editable.(Like a table with 100 columns and we should be able to input something and search / modify the data and submit to DB).Which approach is suitable for this requirement? Should i go with Record Type / Editable Grid.(I am aware that the performance may be slow due to 100 columns. But business want to evaluate how it looks like and see the performance)
Discussion posts and replies are publicly visible
Hello Prasad Ramekar,
Record Type should be a better option here where you can display the most relevant fields on the grid and after user selection, show an interface with all the 100 fields to update. Also, Appian records are optimized and performance efficient with 1,000,000 records synced in the data server from (v 21.4).
Having 100 columns in an editable grid means horizontal scrolling which is not a good user experience.
Regards,
Ricky