Why doesn't my notebook display widgets when I use 'dbutils' while it is displayed with '%sql CREATE WIDGET'?

daindana
New Contributor III

The widget is not shown when I use dbutils while it works perfect with sql.

For example,

%sql
 
CREATE WIDGET TEXT state DEFAULT "CA"

This one shows me widget.

dbutils.widgets.text("name", "Brickster", "Name")
dbutils.widgets.multiselect("colors", "orange", ["red", "orange", "black", "blue"], "Traffic Sources")

This one shows nothing even though I can see `Command took 0.03 seconds` message.

Also, I can get results from widget even though I cannot see it when I use codes below.

name = dbutils.widgets.get("name")
colors = dbutils.widgets.get("colors").split(",")
 
html = "<div>Hi {}! Select your color preference.</div>".format(name)
for c in colors:
  html += """<label for="{}" style="color:{}"><input type="radio"> {}</label><br>""".format(c, c, c)
 
displayHTML(html)

I attached images.dbutils get info from widgetdbutils widget creation

Ryan_Chynoweth
Databricks Employee
Databricks Employee

Hi @DAIN KIM​ , I tried to reproduce your issue but was unable to. Which language of notebook are you using (python,sql)?

And just to be clear, the python dbutils.widget.text does not show up at the top of the notebook?

daindana
New Contributor III

Hello, Ryan! For some reason, this problem is solved, and now it is working perfectly! I did nothing new, but it is just working now.

Thank you!:)

View solution in original post

That is great to hear! It seemed like an odd issue but glad it all worked out.