Home / QIN / Field Properties

Field Properties

Syndicate content
More
How do I stop my append-only fields from being truncated when exporting to Excel?

'Append Only' fields that have the "Show the name and date on their own line" setting turned on do not export to Excel correctly because they contain the leading dashes. Data gets cut off because Excel sees the leading dash and reads it as a numeric field which has a limited size.

February 5th, 2009 - 6:02 PM
0 comments
Tags:
More
How can I find duplicate values in a specific field?

The easiest way to find places where the same value is used in the same field across multiple records is to use a summary report. To do this, click the name of the table you are interested in finding duplicate field values for and select Create a new Report. Within the Report type section, select Summary. Now set the view properties to the following:

February 5th, 2009 - 6:02 PM
0 comments
Tags:
More
How do I create a delete record link that can be clicked on from a report?

Just create a Formula URL field and use the following as its formula:

"javascript:if(confirm ('Are you sure you want to delete this record?')){location.assign('/db/" & Dbid() & "?act=API_DeleteRecord&rid=" & [Record ID#]& "&rdr=" & URLEncode(URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=7")) & "')}"

February 5th, 2009 - 6:02 PM
0 comments
Tags:

© 1997-2013 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit