Vertical Data Entry List/Table

[mviksne]

Thank you for the suggestion!

I followed some tutorial videos and got a flex repeater working. However, I think for aesthetic purposes I would prefer to move forward with using tables.

My next question seems very simple, but I have not found an answer online that makes sense to me:

I need to have the "entry" table to have the same number of rows as the reference table. I managed to do this by creating a query that looks at the database table that the reference table is pulling from and returns blank values for each row. However, the cells are no longer editable.

Here is the query I used:

SELECT '' as Target
FROM   referenceTable 

I have looked through the following thread which appears to address something similar, but I had no luck by adding a column instance.

Perspective table editing help

Add a set of props.columns corresponding to the number of columns you want to show. In each one, set the field property to the column name, then you can make editable true, resizable true, etc. if you need to programmatically create a dynamic number of columns, you can right click-copy the entire column to get the JSON, then use: import json json.reads columnJSON = '<json goes here>' columnSet = [] for i in range(columnCount): columnSet.append(json.reads(columnJSON % (<if you want to use b…

This is the main post I tried:

I do not need to dynamically create columns, so I did not include the code.

The next step will be to loop through the entry table and add the entered values to a list. I have also been struggling with this. It seem "toPyDataSet" does not work with perspective tables.

Any help is greatly appreciated!