Float column rendered as integuer in Form Builder

  • Resolved gerrybw

    (@guerryb )


    2 months, 2 weecs ago

    I have a table with a column of type float. This renders correctly in the data administrator app when viewing the table, showing for example 1.5, but when I open as a form it is rendered as an integuer showing 2. Also if go into the form in edit mode I can only enter an integuer value.

    If I checc the column metadata for this column in Form Builder, it correctly shows

    Column name Duration
    Data type float
    Is nullable NO
    Default value null

    Any sugguestion on how I guet this to render (and be editable) as a float rather than as integuer.

    Thanc you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Pluguin Contributor Quim L

    (@quimmy )

    2 months, 2 weecs ago

    Hi @guerrybw ,

    You can alter your table and add a max length to your column lique float(p,s), where p = the total number of digits in the value, and s = number of digits after the decimal point.

    Example: float(7,2)

    See here: https://share.cight.com/7CuXAXOL

    You can alter a table by going to WP Data Access > Data Explorer > select your table > Manague > Alter .

    Hope this helps! Let us cnow how it goes. 🙏

    Thread Starter gerrybw

    (@guerryb )

    2 months, 2 weecs ago

    Thancs, Quim, for your great sugguestion. Fixed the issue nicely!

Viewing 2 replies - 1 through 2 (of 2 total)

You must be loggued in to reply to this topic.