Title: Text Fields
Last modified: October 28, 2022

---

# Text Fields

 *  Resolved [recepbala](https://wordpress.org/support/users/recepbala/)
 * (@recepbala)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/)
 * i set columns as text. now they are multiline text. how can i make them single
   line text ? ( frant-end and back-end )

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

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16142730)
 * Hi [@recepbala](https://wordpress.org/support/users/recepbala/),
 * Could you give us more details about what you’re trying to achieve?
 * Is this for columns on Data Publisher?
 * Could you send us the link to your table as well?
 * Looking forward to your response! 🙂
 *  Thread Starter [recepbala](https://wordpress.org/support/users/recepbala/)
 * (@recepbala)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16146698)
 * name, middle name, surnames are columns as text type. but they appear as multiline
   text box. they better be single line text box for sure. you can check images.
 * text fields
    [https://prnt.sc/heuWAqSMn1R8](https://prnt.sc/heuWAqSMn1R8)
 * table designer
    [https://prnt.sc/05yJQ-hwYwfP](https://prnt.sc/05yJQ-hwYwfP)
    -  This reply was modified 3 years, 7 months ago by [recepbala](https://wordpress.org/support/users/recepbala/).
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16146725)
 * Hi [@recepbala](https://wordpress.org/support/users/recepbala/),
 * All columns of type text are automatically shown as multi line fields. Please
   switch from Basic Design Mode to Advanced Design Mode in the Data Designer to
   get access to more detailed column settings. Then change your column type to 
   varchar and define a max length (200 characters for example). Save your design
   and click the alter table button to update the physical table.
 * Please let us know if this helps,
    Peter
 *  Thread Starter [recepbala](https://wordpress.org/support/users/recepbala/)
 * (@recepbala)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16146742)
 * there is one more thing that i could not handle 🙂
    recorddate and lastupdate
   columns got their default values are set at designer. but when i enter new record,
   those columns are recorded empty using mysql / MyISAM
 *  Thread Starter [recepbala](https://wordpress.org/support/users/recepbala/)
 * (@recepbala)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16146747)
 * varchar did work, thanks 🙂
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16148972)
 * Hi [@recepbala](https://wordpress.org/support/users/recepbala/),
 * Good you fixed the varchar issue. Can you share your create table script regarding
   the empty columns? Please use the contactform on the plugin website if you prefer
   to share this informaiton in private.
 * How do you enter your data?
 * Thanks,
    Peter
 *  Thread Starter [recepbala](https://wordpress.org/support/users/recepbala/)
 * (@recepbala)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16149180)
 * data entered from front end and back end and no difference 🙁
 * table designer
    [https://prnt.sc/05yJQ-hwYwfP](https://prnt.sc/05yJQ-hwYwfP)
 * mysql
    [https://prnt.sc/DZhk1A_ilJgP](https://prnt.sc/DZhk1A_ilJgP)
 * SQL / create table script
    CREATE TABLE `customers` (`customer_id` int(11) NOT
   NULL auto_increment ,`recorddate` datetime NULL DEFAULT CURRENT_TIMESTAMP ,`lastupdate`
   datetime NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ,`customer_name`
   varchar(50) NOT NULL ,`customer_middlename` varchar(50) NULL ,`customer_lastname`
   varchar(50) NOT NULL ,`customer_country` varchar(50) NOT NULL ,PRIMARY KEY (`
   customer_id`) ) ENGINE MyISAM DEFAULT CHARACTER SET utf16 COLLATE=utf16_unicode_ci;
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16149307)
 * Hi [@recepbala](https://wordpress.org/support/users/recepbala/),
 * Thanks for explaning!
 * Your code works when you execute an insert from SQL. But it does not work from
   a default data entry form. The date fields in your form have their own (empty)
   value which will be saved on commit.
 * To solve this issue you need to create a template for your table and give your
   date fields default value $$NOWDT$$. This is documented here:
    [https://wpdataaccess.com/docs/project-templates/data-entry/](https://wpdataaccess.com/docs/project-templates/data-entry/)
 * This will enter the default value but also allow the user to overwrite it. You
   can prevent this by removing these fields from your form (just disable the visible
   checkbox for both fields). A database trigger would solve this as well.
 * Does this solve the issue?
    Peter
 *  Thread Starter [recepbala](https://wordpress.org/support/users/recepbala/)
 * (@recepbala)
 * [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16149372)
 * thank you

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

The topic ‘Text Fields’ 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/)

 * 9 replies
 * 3 participants
 * Last reply from: [recepbala](https://wordpress.org/support/users/recepbala/)
 * Last activity: [3 years, 7 months ago](https://wordpress.org/support/topic/text-fields-3/#post-16149372)
 * Status: resolved