Need to create a class registration form with limited spaces

%3CLINGO-SUB%20id%3D%22lingo-sub-19078%22%20slang%3D%22en-US%22%3ENeed%20to%20create%20a%20class%20registration%20form%20with%20limited%20spaces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-19078%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20find%20a%20tutorial%20that%20will%20help%20me%20develop%20a%20class%20registration%20process%20using%20SharePoint.%20I've%20been%20search%20the%20internet%2C%20and%20I'll%20continue%20searching%2C%20but%20I'm%20hoping%20someone%20here%20has%20done%20it%20and%20can%20point%20me%20in%20the%20right%20direction.%20I%20tried%20this%20one%20-%20%3CA%20href%3D%22https%3A%2F%2Fjanikvonrotz.ch%2F2014%2F04%2F07%2Fsharepoint-class-registration-form%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjanikvonrotz.ch%2F2014%2F04%2F07%2Fsharepoint-class-registration-form%2F%3C%2FA%3E%20-%20but%20the%20%22Register%22%20Calculated%20field%20formula%20isn't%20working%2C%20I%20keep%20getting%20an%20error%20about%20the%20syntax.%20The%20formula%20he's%20using%20is%20%3CSPAN%3E%3DIF(Closed%3DTRUE%3B%22Closed%20for%20registration%22%3BIF(RemainingSeats%26gt%3B0%3BCONCATENATE(%22%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2F'%23'%22%20onclick%3D%22'OpenRegistrationForm(%26quot%3B%3BStaticID%3B%26quot%3B)'%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ERegister%3C%2FA%3E%22)%3B%22Class%20is%20Full%22))%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20selecting%20the%20column%20names%20from%20the%20%22Insert%20Column%22%20dropdown%20list%2C%20but%20apparently%20I'm%20still%20not%20doing%20it%20right.%26nbsp%3B%20I%20need%20help%2C%20I'm%20on%20a%20tight%20deadline!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-20107%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20create%20a%20class%20registration%20form%20with%20limited%20spaces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-20107%22%20slang%3D%22en-US%22%3E%3CP%3EWhich%20SharePoint%20version%20are%20you%20using%20(2013%2C%202016%2C%20Online)%3F%3C%2FP%3E%3CP%3EWhat%20is%20your%20list%20separator%20(%22%3B%22%20or%20%22%2C%22)%3F%20-%20You%20are%20using%20%22%3B%22%20in%20your%20formulars!%3C%2FP%3E%3CP%3EHave%20you%20tried%20building%20your%20IF%20statements%20one%20by%20one%2C%20to%20ensure%20each%20one%20is%20working%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-19081%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20to%20create%20a%20class%20registration%20form%20with%20limited%20spaces%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-19081%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20to%20add%20to%20this...%20I'd%20really%20prefer%20an%20easier%20solution%2C%20especially%20since%20I%20only%20have%20a%20couple%20days%20to%20do%20this!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

I'm trying to find a tutorial that will help me develop a class registration process using SharePoint. I've been search the internet, and I'll continue searching, but I'm hoping someone here has done it and can point me in the right direction. I tried this one - https://janikvonrotz.ch/2014/04/07/sharepoint-class-registration-form/ - but the "Register" Calculated field formula isn't working, I keep getting an error about the syntax. The formula he's using is =IF(Closed=TRUE;"Closed for registration";IF(RemainingSeats>0;CONCATENATE("<a href='#' onclick='OpenRegistrationForm(";StaticID;")'>Register</a>");"Class is Full"))

 

I've tried selecting the column names from the "Insert Column" dropdown list, but apparently I'm still not doing it right.  I need help, I'm on a tight deadline!

2 Replies

Just to add to this... I'd really prefer an easier solution, especially since I only have a couple days to do this!

Which SharePoint version are you using (2013, 2016, Online)?

What is your list separator (";" or ",")? - You are using ";" in your formulars!

Have you tried building your IF statements one by one, to ensure each one is working?