In our Dittofi app, we have given users the ability to create custom data tables through the use of custom fields. Our table has a few system fields like and the the user can create additional custom fields, ie:
Column 1 Header | Column 2 Header | Custom Column 1 Header | Custom Column 2 Header
We need these table headers to be sortable A-Z / Z-A when clicked for users.
In the above example, we added sorting to pre-defined column headers from the backend using SQL, but we cannot figure out how to do this for any headers created by the users using the "Create Custom Field" function we've built using the same method. Because we don't know what the field name will be ahead of time, we are using the potential field ID to return the array of objects to sort, but then we get stuck.
This would typically be very easy to accomplish using a different stack by manipulating the data on the frontend, but it does not appear Dittofi allows for this approach.