Search the help documentation

Search:

Can't find what you are looking for? Use the Feedback tab in your app to submit an issue, or email support@ qrimp.com.


idnamedescriptionParentTopic
deleteedit264Hide Inactive Fields from Drop-DownsScenario: Bob is creating a new timesheet, and he's selecting a client from a drop-down. If some of your clients are no longer active, you do not want him to see them in this drop-down.

In this case, the first thing you will have to do is make sure your system has a way of knowing the client is no longer active. If you do not already have a field that tells you whether a client is active, you must [Add an Active/Inactive Field].

Then you will have to set the clients table to only show active clients when users are entering clients records from a drop-down field in another table.

<h2>Get the Table ID of the Clients Table</h2>
<a href="db.aspx?t=HelpTopics&id=1293&vid=11">Find the id of your Table</a> and write it down, copy it to your clipboard, or remember it. You will need to get the right table id number for this to work!

<img class="border" src="attachments/developer.qrimp.com-bdbc81bf-d9fd-42ec-a709-8404428a4f06/clientstableid.png" />
<span class="small">You can find the TableID from Table Management</span>

<h2>Write a SQL query</h2>
To hide an inactive record, you will need to use [SQL] security. Go to your Clients Table. Go to Table Management or Manage Tables. Click the link that says "Configure Table Settings" or "Settings".

Scroll down the Table Settings page to the field called "sqlsecurity". In that textbox, write the following statement, including all punctuation*:

<noeval>('1006'=1048 or Active = 'Y')</noeval>

<strong>Important: Change the id to match the id of your table!</strong>

<img class="border" src="attachments/developer.qrimp.com-ad7e285d-a7ed-4ec2-b5ed-33012a6d5aac/activeequalsy.PNG" />

Now, when Bob is creating a timesheet, he only sees active clients!

<img class="border" src="attachments/developer.qrimp.com-fd9d129a-a606-4b41-bfd4-0f58350af712/filteredclientlist.png" />

<h2>Important: Complete Data Entry is Key!</h2>
If you don't mark each client record as either active or inactive (and the field is empty) the record will be treated the same as if it were inactive. Be sure to mark all clients that you want in the list active!

* You could also write Active <> 'N'. The <> in a sql statement means 'not equal to'.		Creating a Look-up Table