Forum Discussion

BalaAboki's avatar
BalaAboki
Qrew Trainee
8 years ago

Select Case and URL Button Not working/disppears

URL button disappears in Forms and Table with Select Case statement. It work perfectly when using this alone (URLRoot() & "db/bm2icyt3r?a=API_GenAddRecordForm&_fid_29=" &  [Record ID#] & "&_fid_3="  ...
Forms
Formulas and functions
Tables and fields
BalaAboki's avatar
BalaAboki
Qrew Trainee
8 years ago

Inspection Type is the name of the field, and the choice are the  attributes.

Open Inspection Form is where the button should appear.

Note - I still need to expand the Case statement to include other inspection types

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Is there any chance that you have leading or trailing spaces on those choices.
  • BalaAboki's avatar
    BalaAboki
    Qrew Trainee
    8 years ago

    Great - that worked. The lookup Table where the values came from had trailing spaces.

    Thanks

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    I was wearing my special X-Ray glasses and could see those invisible spaces from here.