Skip to main content
Solved

Editable column/field


Forum|alt.badge.img+4
Hi - Hopefully I'm in the right area and also I hope that I am not asking a redundant question.  I did search forums did a search here.  I am working with a view/screen that the user wants a field inserted via column chooser that exists on the form that is used to populate view/screen.  Yes, you can create a custom field which inherits the value of existing field on form and have it become a visible column in screen/view.  I've already done that and that works. But it's READ-ONLY. This new column/field needs to be editable from screen/view as the field it's referencing is editable when viewing the form.  Thoughts?  Thank you all for your consideration.

Best answer by ShawnBerk

If you are talking about moving adding a field from the view screen - typically the data entry single record view to be editable on the overview screen - then sometimes it isn’t possible.  Many of the fields on the single record view are actually in different tables, but just happen to be grouped within a tab under that record.  They can’t be edited from the overview due to referential integrity that is required for the record and parent-child relationships.  Some fields can be made editable from the overview, but usually if they aren’t editable on the overview, there is a reason IFS designed it that way.  You would have to be more specific about the exact field and form you are referring to in order for a complete answer I think.

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • Answer
  • March 11, 2020

If you are talking about moving adding a field from the view screen - typically the data entry single record view to be editable on the overview screen - then sometimes it isn’t possible.  Many of the fields on the single record view are actually in different tables, but just happen to be grouped within a tab under that record.  They can’t be edited from the overview due to referential integrity that is required for the record and parent-child relationships.  Some fields can be made editable from the overview, but usually if they aren’t editable on the overview, there is a reason IFS designed it that way.  You would have to be more specific about the exact field and form you are referring to in order for a complete answer I think.


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • March 11, 2020

Thank you for responding Shawn!  The overview/screen is Inventory Parts.  The form is Inventory Part.  The field is Estimated Material Cost.  And yes, you are correct - this field is located on a tab for the Inventory Part form - however, this field is found in the INVENTORY_PART_CONFIG.  So….hope this helps!


Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • March 17, 2020

@twalterson  - OK then thanks for clarifying.  No, I don’t know of any way to add that field to the Inventory Parts Overview as an editable field.  When we need to update this field in a bulk mode, we do it from a migration job which unfortunately means IT involvement and not user direct updates.


Forum|alt.badge.img+4
  • Author
  • Sidekick (Customer)
  • 8 replies
  • March 17, 2020

Thanks so much for responding Shawn!  That confirms the original prognosis as well.

Thanks!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings