Sharepoint Online. Enter logic in custom list form

%3CLINGO-SUB%20id%3D%22lingo-sub-285376%22%20slang%3D%22en-US%22%3ESharepoint%20Online.%20Enter%20logic%20in%20custom%20list%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285376%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3CBR%20%2F%3EAfter%20a%20few%20years%20disconnected%20from%20the%20evolution%20of%20SharePoint%2C%20I%20have%20emerged%20from%20the%20need%20to%20solve%20the%20problem%20of%20a%20client%20for%20SharePoint%20Online%3C%2FP%3E%3CUL%3E%3CLI%3ECreate%20a%20unique%20identifier%20type%20field.%20Desired%20format%206%20numerical%20digits%20correlative.%3C%2FLI%3E%3CLI%3EPreload%20a%20value%20in%20a%20field%20after%20a%20change%20in%20other%20fields%20in%20the%20same%20list.%20The%20value%20depends%20on%20a%20logic%20according%20to%20the%20values%20marked%20in%20the%20two%20fields%20that%20can%20be%20several%3C%2FLI%3E%3CLI%3EPreload%20a%20value%20in%20one%20field%20after%20a%20change%20in%20another.%20This%20value%20is%20collected%20from%20another%20list%3C%2FLI%3E%3C%2FUL%3E%3CP%3EMy%20first%20approximation%20was%20the%20JS%20code%20that%20was%20executed%20in%20the%20creation%20and%20edition%20form%20of%20the%20list.%20I%20have%20found%20that%20by%20default%20it%20is%20not%20possible%2C%20besides%20that%20there%20is%20a%20modern%20view%20that%20has%20a%20DOM%20totally%20different%20from%20the%20traditional%20one.%3C%2FP%3E%3CP%3EI%26nbsp%3Bthink%20about%20creating%20a%20web%20part%20to%20create%20a%20creation%20and%20editing%20form%20of%20my%20own%2C%20but%20it%20seems%20disproportionate%20to%20what%20needs%20to%20be%20done.%3C%2FP%3E%3CP%3ECould%20you%20have%20any%20indication%20of%20how%20to%20solve%20my%20requirements%3F%3C%2FP%3E%3CP%3EThank!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285428%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online.%20Enter%20logic%20in%20custom%20list%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285428%22%20slang%3D%22en-US%22%3EIf%20you%20have%20a%20developer%20background%20(I%20guess%20so%20%3A-))%2C%20you%20can%20achieve%20this%20by%20means%20of%20a%20SPFx%20Field%20customizer...of%20course%2C%20you%20will%20need%20to%20get%20used%20to%20SPFx%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285395%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20Online.%20Enter%20logic%20in%20custom%20list%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285395%22%20slang%3D%22en-US%22%3EYes%2C%20look%20into%20using%20PowerApps%20custom%20forms%20for%20SharePoint.%20This%20makes%20this%20task%20very%20easy.%20Assuming%20this%20is%20end%20user%20submitted%20data%20that%20would%20be%20using%20a%20form%20then%20these%20fields%20populate%20from%20that.%3CBR%20%2F%3E%3CBR%20%2F%3EShane%20Young%20has%20some%20good%20videos%20showing%20this%20and%20look%20at%20his%20channel%20video's%20where%20you%20can%20find%20any%20other%20getting%20started%20information%20you'll%20need%20about%20PowerApps.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DBadj3_T8zAw%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DBadj3_T8zAw%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
Regular Visitor

Hello,
After a few years disconnected from the evolution of SharePoint, I have emerged from the need to solve the problem of a client for SharePoint Online

  • Create a unique identifier type field. Desired format 6 numerical digits correlative.
  • Preload a value in a field after a change in other fields in the same list. The value depends on a logic according to the values ​​marked in the two fields that can be several
  • Preload a value in one field after a change in another. This value is collected from another list

My first approximation was the JS code that was executed in the creation and edition form of the list. I have found that by default it is not possible, besides that there is a modern view that has a DOM totally different from the traditional one.

I think about creating a web part to create a creation and editing form of my own, but it seems disproportionate to what needs to be done.

Could you have any indication of how to solve my requirements?

Thank!

2 Replies
Highlighted
Yes, look into using PowerApps custom forms for SharePoint. This makes this task very easy. Assuming this is end user submitted data that would be using a form then these fields populate from that.

Shane Young has some good videos showing this and look at his channel video's where you can find any other getting started information you'll need about PowerApps.
https://www.youtube.com/watch?v=Badj3_T8zAw


Highlighted
If you have a developer background (I guess so :-)), you can achieve this by means of a SPFx Field customizer...of course, you will need to get used to SPFx