Skip to Navigation


Syndicate content

You can use a Formula – URL field to create a URL that takes a viewer to a specific Web page. Formula - URL fields enable you to combine information from different fields in your application into a single URL. You use the "&" symbol to combine the values of several fields into a single URL or add the value of one or more fields to a URL string.  

September 19th, 2011 - 1:09 PM

The formula looks like this:

Right("00" & Left([IP Address], "."), 3) & "." &

Right("00" & Left(Right([IP Address], -1 + Length([Ip Address]) - Length(Left([IP Address],"."))),"."),3) & "." &

Right("00" & Right(Left([IP Address], -1 + Length([Ip Address]) - Length(Right([IP Address],"."))),"."),3) & "." &

Right("00" & Right([IP Address], "."), 3)

February 5th, 2009 - 5:02 PM

right("000" & floor([octet1]), 3) & "." &
right("000" & floor([octet2]), 3) & "." &
right("000" & floor([octet3]), 3) & "." &
right("000" & floor([octet4]), 3)

February 5th, 2009 - 5:02 PM

If your append only field is called "Notes" then you can create a formula text field that shows the last entry in "Notes" using the following formula:


February 5th, 2009 - 5:02 PM

Create a report with a custom formula column of type "Text". Use the following formula:

Case(DayOfWeek([Your Date Field's Name]), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", 6, "Saturday")

Then sort and group on the custom column.

February 5th, 2009 - 5:02 PM

If you'd like to change the default date format to YYYY-MM-DD throughout your account or app, see the instructions in this help topic:

February 5th, 2009 - 5:02 PM

Let's assume the Date field is called "My Date" and that the Time of Day field is called "My Time of Day". Let's also assume that you want the display format to be:

08-17-2001 01:01:01

Then the text formula to display the date and the timestamp fields together in one cell would be:

[My Date] & " " &

Right("0" & Hour([My Time of Day]), 2)

& ":" &

February 5th, 2009 - 5:02 PM

I have values for four fields representing a quarterly balance in an account. They are filled in successively over time, so at any given time they may not all be filled in.

This is a good place to use the Nz() function. It allows you to use a value if it is not null, but if it is null use an alternate value instead. You can cascade them to successively check each field.

February 5th, 2009 - 5:02 PM

If you place a view link field on your Exact Forms MS Word template this turns into a table with no grouping or subtotals. If you want grouping and subtotals you can use the following method:

~=qdb.GetURL("targetdbid", "API_GenResultsTable^query={'12'.EX.'"+ field["Source Field"]+"'}^^slist=15");~

You'll need to replace


February 5th, 2009 - 5:02 PM