投稿済み Tue, 24 Mar 2020 07:31:14 GMT 、投稿者 Mayra Rossi
Hi, 
there's the possibility to link a decimal field to a select list?

Here the problem:

I have a multicolumns select list "gadget"
Article ID Article name Price
1 Pen 0,30
2 Mouse 15,00

I tried to link this select list to a table field, no problem for "Article name", but I cannot associate "Price" column to the relative decimal field in table field.

There's any solution?

Thanks
投稿済み Sat, 28 Mar 2020 13:33:09 GMT 、投稿者 Craig Heintz SE
Have you tries to use decimal instead of comma for in your price column?

like 0.30 and 15.00
投稿済み Mon, 30 Mar 2020 04:45:51 GMT 、投稿者 Mayra Rossi
Sure! 

Choice of select list works only with textual fields. Maybe a bug?
投稿済み Mon, 30 Mar 2020 15:17:28 GMT 、投稿者 Craig Heintz SE
If your database field is a decimal field and you set your select list as a CSV and use a file connect to access it, you will need to assign the column to an integer in the file connect configuration and then click on the number format and set the decimal to 2 digits.  This made the select list available to me.
投稿済み Mon, 30 Mar 2020 15:25:25 GMT 、投稿者 Craig Heintz SE
Spoke too soon.  I had my database field set for a numberic field and not a decimal.
So back to maybe a bug!
投稿済み Wed, 24 Apr 2024 10:52:22 GMT 、投稿者 Philemon Ted NSANGOU Ingénieur logiciel
Hello Guys.  Anything new about this issue. I have the exact same situation

フォーラムに投稿するためにはログインが必要です。