You can find several options for your field column in the column settings.
To access this setting, go to Form Builder > COLUMNS > navigate to a column > Column Settings.
Default Value #
Default value applied on insert only. Leave empty to use column default constraint.
- Column default constraints defined in the database are automatically applied (current value is NULL)
Examples: #
The following variable returns the WordPress user ID or 0 for anonymous requests.
@wpda_wp_user_id
Returns the current date/time and works with datetime fields only
@now
Other settings: #
- Prefix-Suffix: Adds a prefix and/or suffix to the column content.
- CSS classes: Add CSS classes (separated by spaces) for custom styling.
- Hint: Help text displayed below data entry field.
How can I return username instead of user_id ?
Adding custom session variables is explained here:
https://wpdataaccess.com/docs/variable/wordpress-user-id-in-sql/
See section: Need more WordPress values in SQL?