Automated Action Duplicate

[sgardner478]

When creating an automated action to duplicate a record there are some errors.

1. When choosing "manual entry" for a field, the field is filled in with copied record. It should be empty so that user can fill in field. In below screenshot, several of the fields are "manual entry" and they are already filled in.

2. When using button position of "with selected" or "more actions" or "record listing" a sql error occurs. See screenshot below. When using "on record page" it presents form but has problems noted in #1 above.

[support]

1) It should be empty so that user can fill in field.

There is no option to set it empty. The app just copy current value.

2. When using button position of "with selected" or "more actions" or "record listing" a sql error occurs. See screenshot below. When using "on record page" it presents form but has problems noted in #1 above.

Can't reproduce it. Looks like there is custom sql formula or query with [1414] filed and it's not supported with selected action.

[sgardner478]

Field 1414 entity type is 'user'. There are no special sql formulas.

Auto Action - Duplicate Error 1-21-2023 -4.png (5.57 KiB) Viewed 171 times

Here is the error message..

Database Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[1414])) order by group_name, u.field_7, u.field_8' at line 1
Query: select u.*,a.name as group_name from app_entity_1 u left join app_access_groups a on a.id=u.field_6 where (u.field_5=1 or u.id in ([1414])) order by group_name, u.field_7, u.field_8
Page: /3.3beta/index.php?module=items/processes&id=18&entity_id=27&path=36-162/26-47/27&redirect_to=items&reports_id=1277
#0 includes/functions/database.php(87): mysqli_query(Object(mysqli), 'select u.*,a.na...')
#1 includes/classes/fieldstypes/fieldtype_users.php(75): db_query('select u.*,a.na...')
#2 includes/classes/fieldstypes/fieldtype_users.php(145): fieldtype_users::get_choices(Array, Array, '[1414]')
#3 includes/classes/fields_types.php(984): fieldtype_users->render(Array, Array, Array)
#4 modules/items/views/processes.php(413): fields_types::render('fieldtype_users', Array, Array, Array)
#5 index.php(27): require('/home/********/...')
#6 {main}

[support]

Please reproduce this issue on personal demo and give me the link to the demo
https://www.rukovoditel.net/demo.php