Notifications
Announcements
I want to develop employee bio data form. there is section in the form that is a repeating section. I want a situation where the employee can go back to edit the information. Attached is the screenshot of the form look like on paper.
@whykay1029 What data structure do you have in your database to store this information? Is it a flat structure where everything goes into one table/list or you have a normalised structure?
yes, A flat structure where everything goes to a sharepoint list. also have the ability to edit it.
@whykay1029 You have 2 repeating sections. If the number of entries in them is fixed, a flat structure is fine (provided the requirements do not change in the future).
Having a flat structure (just 1 share point list) is not generally advisable for repeating data. You could rather have 3 Lists. 1 for the main details, 1 for the Education details and another for the previous employment details. You can have an EmployeeID column in the 2nd and 3rd lists that stores the ID from the 1st list.
Please consider which way you want to go. Either way give me a buzz if you need more help!
@CNT, how can I achieve it without using flat structure. I want the user to have the right to go back and edit the items in the repeating section of the form.
@whykay1029
You could have 3 Lists. 1 for the main details, 1 for the Education details and another for the previous employment details.
You can have an EmployeeID column in the 2nd and 3rd lists that stores the ID from the 1st list.
When you want to store the Education or Previous Employment details to List2 & List3 you will patch all the necessary data along with the EmployeeID field which is the ID for that same Employee in List1. Probably this diagram will explain it better.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
