Forum Discussion

TeelinaHouse's avatar
TeelinaHouse
Qrew Trainee
7 years ago

I want ""Add Courses"" url link button to show when a checkbox is checked.

I want "Add Courses" url link button to show when a checkbox is checked. I am not a coder so here is what I have so far based on community posts - but not working. Help please - If[([Consists of ...
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
7 years ago
You need to have an "else" statement when using an If() statement.  So at the end of your URL you need a comma and two double-quotes followed by a closing parenthesis to close out the If() statement.

If ( [Consists of Several Courses]=true,
URLRoot() & "db/" & [_DBID_CLIENT] & "?a=API_GenAddRecordForm&_fid_279=" & URLEncode ([Record ID#])& "&z=" & Rurl()
,"" )
TeelinaHouse's avatar
TeelinaHouse
Qrew Trainee
6 years ago
Hi, 

I am not sure if in my updating I broke this or I never had the correct code to begin with. Let me re-ask my question. 

When a checkbox is checked I want to show three lookup fields for additional information that is not needed normally.  This code is for adding a new record and I want the user to find and add an existing record.  It is similar to this help question https://community.quickbase.com/quickbase/topics/hiding-fields-when-box-is-checked; regarding, showing rows. I can't find the code for this example. 

Thanks