Configure URL Fields

So you've snapped and posted photographs of all your Hummel collectibles and you'd like to share them with the world. Of course, you've inventoried your entire collection in a QuickBase. Now, you want to connect each record with its corresponding image, but the images all live on your "Hot Hummels" Web site. Sure, you could create a file attachment field to store and show images within each QuickBase record, but you'd rather not store them in two places.

URL fields to the rescue! QuickBase URL and URL Formula fields let you store and compose hyperlinks that deliver whatever page you wish to a viewer's browser. The URL field type you choose, depends upon what you'd like to do:

FAQ - What if I want all records to show the same URL?
If you want each record to contain a link to one particular Web site, create a plain URL field. Open the field's properties page and set the Default to be whatever URL you want. Save changes. Add the field to forms or reports and make it a "Read-only" type field. That way, the one address you entered appears to each viewer, but no one can edit it.

To create a plain URL field:

  1. Create the URL field.

    Add a new field. Name it something like "Company Web site" or whatever describes the type of URL that users will enter. Select URL as the field type. When prompted, add the field to forms where you want it to appear.

  2. Open the field's properties page.

  3. Set URL display preferences.

    Your URL field doesn't necessarily need to show a huge URL that's hard for average readers to parse out. Instead, the link it displays can contain a more informative label like "Company Web site" or "View product image" or whatever you want. To show more descriptive text, enter the term you want in the Display section's Link text  field.

    You can also tweak format with the following options:

  4. When you're done setting preferences, click Save.

On add or edit forms, users will be able to enter Web addresses in the new URL field. On display forms, the field displays as a hyperlink. Viewers can click the link to see the Web page specified.

To create a Formula-URL field:

  1. Create a field to contain the portion of the URL that users enter.

    Create a Text field (read how to add a field) in which users can enter a portion of your URL. For example, this may be an image file that lives on the Web or an HTML page that contains information relevant to the record. Add this field to forms on which it should appear.

  2. Add a Formula-URL field to the same table.

  3. Open the field's properties page.

  4. Compose the formula.

    Within the Formula box, type in the formula that generates the working hyperlink that this field will display. This formula should begin with the start of your URL in quotes, followed by an ampersand and then a field reference to the field whose value completes the address. For example:

    "http://www.hothummelsinc.com/images/" & [Image Name]

  5. Set display preferences.

    Formula-URL fields offer the same display settings as plain URL fields. To learn about all your options, please read Step 3 in the preceding section.

  6. Click Save.

    Now whenever a user enters a file name in the field you created in Step 1, QuickBase automatically generates a working URL that opens that file in a viewer's browser.

Note: If your Formula-URL field includes an API call and your application requires application tokens, you'll need to insert the appropriate token in the API call.

Related Topics

 

This page refers to an older version of QuickBase. Online help is now located at http://www.quickbase.com/user-assistance/default.html.

 

Return to top   

© 1999-2013 Intuit Inc. All rights reserved. Legal Notices.