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 Quick Base. 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 Quick Base record, but you'd rather not store them in two places.

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

  • When you want users to type in an entire URL for a record they're entering, create a plain URL field. For example, say users are entering company information into your Quick Base. A URL field lets them enter the company's Web site address. Once they save, Quick Base displays the field as a link that delivers the Web site to any viewer.

  • When you want users to enter part of a URL (like the image file name of a Hummel figure on your Web site) use a Formula-URL field. You can compose the formula field to always include the start of your Web site's URL. When you create another field (something like Image Name) then you or a viewer can use it to enter only the file name that completes the URL. Format your URL formula field to concatenate (string together) the start of the URL and whatever file name lives in the Image Name field to get a custom URL for each record.

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 value 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:

    • Don't show 'http://' when showing the URL. Turn on this checkbox to shorten the URL to a more digestible length by removing extras from the beginning. So, instead of, viewers would see only Or, if your URL ends with a file name, Quick Base displays only the file name.

    • Display as a button. If you really want to emphasis to users that they can "click here" to see a picture or related Web page, then turn on this checkbox to display the URL field as a button instead of a blue underlined link.

    • Open target in new window. If you don't want viewers to stray away from your Quick Base application, turn on this checkbox. When you do, the URL field's link opens a new instance of the browser in which to display the link's destination. The Quick Base screen from which viewers launched the link still displays underneath the new window.

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

When editing a record, app users will be able to enter Web addresses in the new URL field. When viewing a record, the URL field appears as a link or button.

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 the formula that generates the link 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:

    "" & [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, Quick Base 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. (API calls and app tokens are not available to accounts on the Quick Base Essential plan.)

Related topics: