Allow users to add fields "on the fly"

[RDmitchell]

Expected Behavior

Allow users to add fields (presumably to the JSON blob field) "on the fly" in the program as needed, without importing a file to create those fields.

Actual Behavior

n/a

Steps to Reproduce

n/a

Instance Information

n/a

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[RDmitchell]

@nllong / @macintoshpie -- having this functionality came up in a call with Washington DC -- they would really like this ability.

[macintoshpie]

Interesting, do you know their use-case? Are there just one or two properties that are missing a column for some reason?

[RDmitchell]

@nllong -- do you remember if Andrew Held mentioned what they need it for?

I can email him to get more specifics if that is useful.

[nllong]

They want to add a column such as "User Verified" and have the user edit it on the Inventory Detail page and update the field from a 0 to a 1. I imagine they would then use a DQ rule to add a label to the properties that haven't been verified.

[macintoshpie]

Not sure when we'll pick this up, but just to capture some thoughts

• you should only be able to create new columns from the Organizations Column Settings page
• it should be an extra_data column

[RDmitchell]

@macintoshpie -- yes, those are what we were thinking

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[RDmitchell]

I think this issue is still relevant and should be kept open.

[isalanglois]

@RDmitchell I'll move it to the new board

[github-actions[bot]]

This issue has been automatically marked as stale because it has not had recent activity within 60 days. It will be closed if no further activity occurs. Thank you for your contributions.

[RDmitchell]

see #3780 Column Settings: getting 520 error when making a new column but column is created

[RDmitchell]

@haneslinger / @isalanglois -- see the bug above that I found when testing last week.

[RDmitchell]

@haneslinger / @axelstudios -- is this bug still a problem? The related issue is in test and maybe it shouldn't be?

[RDmitchell]

See the comments I just added to #3780

[RDmitchell]

Depending on the answer to #3780, I will close both of these issues.

[RDmitchell]

I am repeating the comment I made in #3780

Instance: LBNL staging SHA: 992862f09 Release: 2.17.1 Org: LBNL Test 200

When I added the field in Column Settings, this error was displayed in Developer tools.

However, the program finished adding the field (the spinner stopped) and it was displayed in the Column Settings List

I could edit the field and add data to it in the Property Details view, and it displays properly in the Property List view

@haneslinger -- do we need to worry about that error? It's not something the user sees, and the program finished making the field. ??

[haneslinger]

This is fixed in https://github.com/SEED-platform/seed/pull/3791

[RDmitchell]

instance: dev1 SHA: c8b79f627

Added a column, no error !! Thanks !