Syncing with Remote Database failing

Submitted by prashant on 2025/06/29 14:02
Forums

HI,

I have database on local machine which I am trying to sync . 

localhost\sqlexpress
database - items
username- xx | password xxx
table - quickcapture
primarykey - recordid
column to sync - Task

This is 100% working connection string , tested via powershell

$connectionString = "Server=localhost\SQLEXPRESS;Database=items;User ID=xx;Password=xxx;Trusted_Connection=False"
$connection = New-Object System.Data.SqlClient.SqlConnection $connectionString

Font colors in dark mode when using background colors

Submitted by LM77 on 2025/06/29 02:16
Forums

When I use dark mode and change the background color (say, to red), the default font color (=Text Fore Color) changes from dark ("None") to white, rendering the resulting text extremely difficult to read (see Screenshot 1, attached).

I have found a workaround, by manually changing the Text Fore Color to Olive Green under such circumstances (see the last item in the grid in Screenshot 2, attached), but this is a bit cumbersome.

Is there any way to ensure by default that the Text Fore Color comes out readable when using dark mode and changing the background color?

Drop down fields

Submitted by Jon on 2025/06/13 15:33
Forums

I have several fields configured as drop downs. Some are "Auto-list of values" others "Fixed list."

How do I open the drop down with the keyboard? And can I use type ahead to begin and select a value accordingly?

I used to know this, but now cannot figure it out.

Thank you for your help.

Jon

Group by grids

Submitted by iqhlp on 2025/04/27 19:33
Forums

i'm trying to pull items from the base into a new grid and group matching items by what grids they belong to.  i know theres a shownin field in the properties which lists all the grids to which an item belongs - but i cant seem to enter it in the grid as a field. how can i get it as a field in a grid and th en group by it?

example

source:

task 1 is in grids: a
task 2 is in grids: b
task 3 is in grids: a and b

 

results wanted:

grid a

- task 1
- task 3

grid b
- task 2
- task 3

Calendar - create 8 day view

Submitted by Maxbear35 on 2025/04/18 19:34
Forums

I am writing to see if it's possible to create an eight-day view to the calendar. Currently, the calendar offers 1, 3, 5, 7, and 31-day views, which are all very useful. However, an eight-day view would allow for a full week to be displayed from Saturday to Saturday, providing a more comprehensive and flexible overview of the week.

I believe this would be a valuable addition for many users who prefer to plan and organize their schedules based on a Saturday-to-Saturday week. Perhaps with a filter. 

Thank you for your time and consideration. Any help would be appreciated. 

Deleting unneeded fields

Submitted by Maxbear35 on 2025/03/19 17:48
Forums

When I imported data from ECCO, IQ also brought in all the ECCO fields, many of which are either redundant or no longer useful. To streamline the data in IQ, I’ve been attempting to remove some of the zero-entry fields. However, I’ve noticed that certain fields cannot be deleted, as the delete option is greyed out.

Could you please advise if there’s a way to remove these unnecessary fields?

Updating (refreshing) the "Link Text" after creating an "Inline Item Link"?

Submitted by dderkits on 2025/03/17 17:13
Forums

Scenario:

1) Create new Item X, containing a text string such as "this is original text".

2) Create new Item Y and type "[[" within Item Y to bring up the "Embed Link to..." dialog.

3) In Item Y, use the dialog to embed a link to Item X (with "Use Item Text" checkmarked in the dialog).

4) Now, Item Y displays a clickable link ("this is original text") that points to Item X.

5) Modify the text of Item X, such as "this is MODIFIED NOT original text".

Lost sub-items

Submitted by WayneK on 2025/03/02 09:02
Forums

I just discovered that I've lost many sub-items that I thought were assigned to multiple parents.

1) Start with an item and sub-item in one grid, and a 2nd item in another grid =

 

2) Assign Sub-item to grid-2.  This grid now has two top-line items =