I have an APP that gets data from an SQL database. This database updates every minute. In one of the columns there is data i want moved to another column (but i cannot get it moved in the actual database).
Example:
Table: Category
Columns: [Pumps], [MATS], [Re-rents], etcโฆ
In my APP data structure i want to be able to move some items from [re-rents] into the column [pumps] based on their item description.
Is that possible?
Reason: in column [re-rents] there are many MATS and pumps that my company wants the app to show in their appropriate columns (but to move all of them daily in the database is NOT feasible)
You could consider adding a column that contains the Name of the column (โPumpsโ or โRe-rentsโ) where it should display and an app formula in the Pumps and Re-rents columns.
Virtual?
Virtual only if you can compute the column name from other column values else it has to be real.
User | Count |
---|---|
40 | |
32 | |
30 | |
17 | |
16 |