Title: Float column rendered as integer in Form Builder
Last modified: November 3, 2025

---

# Float column rendered as integer in Form Builder

 *  Resolved [gerrybw](https://wordpress.org/support/users/gerrybw/)
 * (@gerrybw)
 * [7 months, 1 week ago](https://wordpress.org/support/topic/float-column-rendered-as-integer-in-form-builder/)
 * 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 floatIs nullable NODefault 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](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [7 months, 1 week ago](https://wordpress.org/support/topic/float-column-rendered-as-integer-in-form-builder/#post-18706000)
 * Hi [@gerrybw](https://wordpress.org/support/users/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](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](https://wordpress.org/support/users/gerrybw/)
 * (@gerrybw)
 * [7 months, 1 week ago](https://wordpress.org/support/topic/float-column-rendered-as-integer-in-form-builder/#post-18706432)
 * 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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [gerrybw](https://wordpress.org/support/users/gerrybw/)
 * Last activity: [7 months, 1 week ago](https://wordpress.org/support/topic/float-column-rendered-as-integer-in-form-builder/#post-18706432)
 * Status: resolved