How to get Variable textbox to work correctly
I am trying to create a lookup using a variable where the user can type in the ID of a record and then the information for that record will display in a textbox card.
Everything seems to work as expected other than pickheaderId will only search on the first record and not the whole dataset.
Here's my variable calc:
When i search for any other pickheaderid other than the first record pickheaderid:
You can see that the textbox is displaying the first records pickheaderid instead of the address of the pickheaderid im searching for.
When I search for the first records pickheaderid:
It works correctly only for this record.
Does anyone know why the pickheaderid is only looking at the first record and not at others?
Note: I understand that I can just create a filter card and it will do the same thing — but i want to do it this way.
Best Answer
-
The text box returns the first record it finds. Since your beast mode is returning just the ID in the ELSE clause you get the first ID.
Remove the ELSE clause from your case statement and then filter your text card so that the value is not null.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
The text box returns the first record it finds. Since your beast mode is returning just the ID in the ELSE clause you get the first ID.
Remove the ELSE clause from your case statement and then filter your text card so that the value is not null.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Sweet that worked! Thanks @GrantSmith
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive