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:

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:

  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:


Go back      |       

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.