Question

Table that is set, and read only but allows multiple comparisons?

Forms How To

Updated June 3, 2019

asked on May 21, 2019 • Show version history

So I work for a non-profit and we need to compare households incomes to the federal poverty guideline, based on household size.

I was hoping to create a table that shows 1 - 5 person household size for columns, and then the rows would be 100%, 51-80%, 31-50%, 0-30% so that there is a chart of numbers for the staff to compare to income. If I make the chart have default numbers it duplicates the same amount for the entire column, which isn't what I want. Is there a better way to do this?

See attached for an example of what I am trying to create in an table that can be updated as the guidelines change.

*edited to add image of duplication that I managed to create*

FPGchart.jpg (52.11 KB)

| Download

issue.jpg (45.72 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on May 21, 2019

Two options might be

1) Use CustomHTML to build the table since the submitter won't be editing the values anyway. To edit the values you just update the HTML.

2) Add the data to a SQL database table and populate it with a lookup. To update the values you update the values in the database.

2 0

replied on June 3, 2019

I ended up coding it, as we don't have the information in the database. Thanks!

0 0

Replies

replied on May 21, 2019

I agree with #2. We do the same thing for FPL in a SQL table. Then you can update it with a SQL Agent task that periodically reads a spreadsheet for current data. I swap the columns and rows though, so you have the household size as rows and the FPL levels as columns. We use this same table for several programs with different guidelines and it works well.

2 0

replied on June 3, 2019

We don't keep the data in the database unfortunately, so I custom coded it with HTML. Thanks for the input though!

0 0

You are not allowed to follow up in this post.

Question

Question

Table that is set, and read only but allows multiple comparisons?

Answer

Replies

Sign in to reply to this post.