Title: Cannot add double values
Last modified: April 27, 2024

---

# Cannot add double values

 *  Resolved anonymized-2514315
 * (@anonymized-2514315)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/cannot-add-double-values/)
 * I like the plugin a lot, but it seems there is quite a bug in the plugin.
 * When I try to add a value to a table row where the field is DOUBLE I cannot add
   a decimal value.
 * SO
 * 4.132231405
 * or
 * 4,132231405
 * Both jump automaticly to
 * 4132231405
 * SO without the decimal. This is a real problem for me as I need to add decimal
   values.

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

 *  Thread Starter anonymized-2514315
 * (@anonymized-2514315)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/cannot-add-double-values/#post-17717538)
 * It seems this is only with new rows
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 1 month ago](https://wordpress.org/support/topic/cannot-add-double-values/#post-17720179)
 * Hi @tvdsluijs,
 * Thanks for the post and sorry to hear you’re encountering issues.
 * Can you try modifying the column’s data type into decimal(p,s) format where p
   = the total number of digits in the value, and s = number of digits after the
   decimal point?
 * Example: `decimal(7,3)`
 * 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. 🙏

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

The topic ‘Cannot add double values’ 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: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 1 month ago](https://wordpress.org/support/topic/cannot-add-double-values/#post-17720179)
 * Status: resolved