Platform

 View Only

 Editable Tables and drop down Menus

Jump to  Best Answer
  • TBMStudio
Luis Dinis's profile image
Luis Dinis posted Wed August 09, 2023 08:48 AM

Hi is anyone out there using Editable tables where you have possible values for a dropdown menu?  Ever since we upgraded a few weeks ago to 12.10.9 the dropdown menus stopped working and basically just state that it's loading but never load.  Originally tried a cache clear and it worked, but some folks tried that and still got the dropdowns loading.  But in the past week, no one can get the dropdowns to load at all making that report unusable.  We have a ticket in with support and engineering has been looking into it, but nothing so far.  Just wondering if folks have experienced similar issues and if they had a resolution.


#TBMStudio
Attachment  View in library
Capture.PNG 11 KB
Guillermo Cuadrado's profile image
Guillermo Cuadrado  Best Answer

We were recently upgraded to 12.10.10 and the drop down most definitely works (just re-tested). The options, as described by @Luis Dinis above, is a comma-separated list of values.


#TBMStudio
Michael Enslein's profile image
Michael Enslein

@Luis Dinis Can you post the formula that you use for the lookup?   I have seen this before but usually only when I am setting up a lookup.  If not @Ed Hayman is the master of Editable tables and might be able to give it a look.  


#TBMStudio
Luis Dinis's profile image
Luis Dinis

There's only one field that has a formula the others don't have formulas, but all the columns with drop downs just show loading not the values when it used to work before prior to our upgrade. Here's one that has a formula in possible values: %ALSAC Vendors Upload Transform/! LIMIT_COLUMNS[Vendor_Name]     But most have just possible values listed with a comma in between them.  EX.  Possible Values-  Savings, Avoidance   

Thanks


#TBMStudio
Michael Enslein's profile image
Michael Enslein

@Luis Dinis  Yes looks like that is correct.  We just updated it to 12.10.10 over the weekend and everything seems to working.  Hope you figure this out.  


#TBMStudio