302 Found

Found

The document has moved here.

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How can I create custom URLs using field values in my application?

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.  

Example 1:

You have a field in your application called “UPS Tracking Number”.  You want to create a link to the UPS package tracking site that includes specific UPS tracking numbers. The link to track a UPS package is "http://www.apps.ups.com/etracking/tracking.cgi?tracknum=UPS_Tracking_Number&accept_UPS_license_agreement=yes&nonUPS_title=QuickBase%20Package%20Tracking%20System". To make a custom URL for specific tracking numbers, create a Formula - URL that includes the value from the UPS Tracking Number field in the appropriate location within the URL.  To do this:

 

  1. Open the table to which you want to add the Formula - URL field from the Table bar.

  2. Click Settings.

  3. Select Fields.

  4. Click the New Fields button.

  5. Enter a Label for the field (such as “UPS Link”) and then select Formula –URL from the dropdown menu.

  6. Click Add.

  7. On the Fields screen, click on the name of the field you just created. 

  8. In the Display Text field, enter "Track It...".

  9. In the Formula text box, enter the following: "http://www.apps.ups.com/etracking/tracking.cgi?tracknum="&[UPS Tracking Number]&"&accept_UPS_license_agreement=yes&nonUPS_title=QuickBase%20Package%20Tracking%20System"

  10. Click Save.

  11. If the field was not automatically added to the application’s forms and reports, add it to forms and reports as needed.

 

 

 

Example 2:

Your company uses multiple shipment carriers to ship packages.  Your application includes a "Shipment Carrier" field that contains the values: "FedEx", "UPS", "FedEx Ground", and "FedEx Freight".  Your application also includes a "Tracking Number" field. You can create a Formula - URL field to create a custom URL to track the package based on which shipment carrier is used and the package's tracking number.  To do this:

 

  1. Open the table to which you want to add the Formula - URL field from the table bar.

  2. Click Settings.

  3. Select Fields.

  4. Click the New Fields button.

  5. Enter a Label for the field (such as “Package Tracking Link”) and then select Formula –URL from the dropdown menu.

     

  6. Click Add.

  7. On the Fields screen, click on the name of the field you just created. 

  8. In the Display Text field, enter "Track It...".

  9. In the Formula text box, enter the following: Case([Shipment Carrier],"UPS","http://wwwapps.ups.com/etracking/tracking.cgi?tracknum="&[Tracking Number]& "&accept_UPS_license_agreement=yes&nonUPS_title=QuickBase%20Package%20Tracking%20System","DHL","http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber="&[Tracking Number],"FedEx","http://www.fedex.com/cgi-bin/tracking?action=track&language=english&cntry_code=us&initial=x&mps=y&tracknumbers="&[Tracking Number],"FedEx Ground","http://www.fedex.com/cgi-bin/tracking?action=track&language=english&cntry_code=us&initial=x&mps=y&tracknumbers="&[Tracking Number],"Fedex Freight","http://www.fedexfreight.fedex.com/protrace.jsp?as_type=PRO&emailfax=&as_entryPage=Pro%20Number&as_pro="&[Tracking Number])

  10. Click Save.

  11. If the field was not automatically added to the application’s forms and reports, add it to forms and reports as needed.

 

 

Example 3:

Imagine that your application contains a comprehensive list of orchid types and you want each record to contain a link to the related picture on your web site. You have one field in your table called “Site URL” that contains your Web site address and another field called “Image” that contains the name of the related image.  You could compose a formula that combines them, creating a link in each record that leads to a different image on your Web site. The formula for the Formula – URL field would be: [Site URL]&[Image]

Advanced Use of Formula - URL Fields:

You also can perform more complex actions using the Formula – URL field, such as combining multiple API calls into a single link or button. The following Knowledge Base articles provide examples of using the Formula – URL field for more complicated actions:

302 Found

Found

The document has moved here.