TYPO3 Core

If you like this idea, I could try the implementation.

Lidia Demin wrote:

If you like this idea, I could try the implementation.

Hello! Is there a any the positive solution of this?

I'll take a look in the next days.

Lidia Demin wrote:

I haven't started yet, because there was no feedback to this proposal. But seems, it just got a +1 from you ;)

Thanks!

Yes, you are right. I want to add to the DB via ext:form not only one value and two or more values. I mean this is about `type: MultiSelect` and `type: ImageUpload`. This types which can have not one value and two or more values or can to be empty.

For example, I have:

      -
        properties:
          systemCategoryUid: ''
          validationErrorMessages:
            -
              code: '1475002976'
              message: 'Min 1'
            -
              code: '1475002994'
              message: 'Max 3'
          fluidAdditionalAttributes:
            required: required
        defaultValue: ''
        type: MultiSelectSysCategory
        identifier: categories
        label: 'Categories'
        validators:
          -
            identifier: NotEmpty
          -
            options:
              minimum: '1'
              maximum: '3'
            identifier: Count
      -
        properties:
          saveToFileMount: '1:/user_upload/'
          allowedMimeTypes:
            - image/jpeg
            - image/png
            - image/bmp
          imageLinkMaxWidth: '500'
          imageMaxWidth: '500'
          imageMaxHeight: '500'
        type: ImageUpload
        identifier: attachment
        label: Attachment

and finisher:

 -
    options:
      -
        table: tx_foo_domain_model_foo
        mode: insert
        databaseColumnMappings:
          pid:
            value: '0'
          datetime:
            value: '{__currentTimestamp}'
          tstamp:
            value: '{__currentTimestamp}'
          crdate:
            value: '{__currentTimestamp}'
        elements:
          categories:
            mapOnDatabaseColumn: categories
          title:
            mapOnDatabaseColumn: title
          bodytext:
            mapOnDatabaseColumn: bodytext
          attachment:
            mapOnDatabaseColumn: fal_media
      -
        table: sys_category_record_mm
        mode: insert
        elements:
          categories:
            mapOnDatabaseColumn: uid_local
        databaseColumnMappings:
          tablenames:
            value: tx_foo_domain_model_foo
          fieldname:
            value: categories
          uid_foreign:
            value: '{SaveToDatabase.insertedUids.0}'
      -
        table: sys_file_reference
        mode: insert
        elements:
          attachment:
            mapOnDatabaseColumn: uid_local
        databaseColumnMappings:
          table_local:
            value: sys_file
          tablenames:
            value: tx_foo_domain_model_foo
          fieldname:
            value: fal_media
          tstamp:
            value: '{__currentTimestamp}'
          crdate:
            value: '{__currentTimestamp}'
          uid_foreign:
            value: '{SaveToDatabase.insertedUids.0}'
    identifier: SaveToDatabase

The identifier: categories can to pass to the DB few values but the finisher give possibility save only one value

The identifier: attachment can to pass few values too

at the moment can save only one value

I hope that you you are understood my bad English ... sorry for my English is my bad

I hope that not only I, it who want this possibility.

I tried to save categories from a MultiCheckbox filed in sys_categories (and of course sys_category_record_mm).
https://stackoverflow.com/questions/60698065/savetodatabase-with-multicheckbox-in-form-how-to-save-values-in-sys-category-re
It seems that the problem is not fixed until now.

I tried it this way:

-
  table: sys_category_record_mm
  mode: insert
  databaseColumnMappings:
    uid_foreign:
      value: '{SaveToDatabase.insertedUids.0}'
    tablenames:
      value: 'tx_myext_mytable'
    fieldname:
      value: 'categories'
    sorting:
      value: '0'
    sorting_foreign:
      value: '1'
    uid_local:
      value: '{category.0}'
-
  table: sys_category_record_mm
  mode: insert
  databaseColumnMappings:
    uid_foreign:
      value: '{SaveToDatabase.insertedUids.0}'
    tablenames:
      value: 'tx_myext_mytable'
    fieldname:
      value: 'categories'
    sorting:
      value: '0'
    sorting_foreign:
      value: '1'
    uid_local:
      value: '{category.1}'

It seems that it is not possible in the moment to write categories - or any 1:many Releation.