Discussions

Expand all | Collapse all

URL formula wildcard for Dropbox and Sharepoint OneDrive

  • 1.  URL formula wildcard for Dropbox and Sharepoint OneDrive

    Posted 10-19-2018 12:10
    I tried adding asterisk to end of URL formula to link to folder on Dropbox.
    The folder name is unique however each folder name also has a date time as part of the foldername at the end.

    The asterisk doesn't work, get an error in Dropbox and also tried with Sharepoint, no success.

    In my formula sample below I was hoping adding an asterisk after Object ID would work at the end of the formula to find the folder with that Object ID. 

    If I leave off the * it works and finds the folder if the folder name has no other characters after the Object ID.

    The issue is that most of the folder names have date and time and other characters after the Object ID as part of the folder name. 

    If(
    [Object ID]<>0, (

    "https://xxx.sharepoint.com/personal/xxx/Documents/ABC/Photo%20Deliverables...">https://gouldbcs-my.sharepoint.com/personal/dgould_gould-bcs_com/Documents/FDEC/Photo%20Deliverables/"&">https://xxx.sharepoint.com/personal/xxx/Documents/ABC/Photo%20Deliverables...;

    If(Contains([Pole_Data Source],"Pink"), "Pink",
    If(Contains([Pole_Data Source],"Green"), "Green",
    If(Contains([Pole_Data Source],"Yellow"), "Yellow", " ")))

    & "%20Line%20Photos/"

    & "xxx-"&
    Left((Right([Pole_Data Source], "-")), " ")&

    "_" & ToText([Object ID])&"*", "")


  • 2.  RE: URL formula wildcard for Dropbox and Sharepoint OneDrive

    Posted 10-20-2018 17:36
    I'm not positive this will resolve your issue, but it may be worth a try.

    In place of the asterisk, use the encoded version %2A.

    Strangely, the Quick Base function URLEncode( ) doesn't recognize this encoding, however other sites confirm this is the proper encoding for the asterisk.

    Let me know if that works for you.
    -Sharon