Float column rendered as integer in Form Builder

  • Resolved gerrybw

    (@gerrybw)


    6 months 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 integer showing 2. Also if go into the form in edit mode I can only enter an integer value.

    If I check 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 suggestion on how I get this to render (and be editable) as a float rather than as integer.

    Thank you.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    6 months ago

    Hi @gerrybw,

    You can alter your table and add a max length to your column like 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.zight.com/7KuXAXOL

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

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

    Thread Starter gerrybw

    (@gerrybw)

    6 months ago

    Thanks, Kim, for your great suggestion. Fixed the issue nicely!

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

The topic ‘Float column rendered as integer in Form Builder’ is closed to new replies.

  • 2 replies
  • 2 participants
  • Last reply from: gerrybw
  • Last activity: 6 months ago
  • Status: resolved