---
title: "Powermail dropdown ergebnis in fremde Tabelle schreiben"
url: "https://www.typo3.net/d/119958-powermail-dropdown-ergebnis-in-fremde-tabelle-schreiben"
source: "typo3.net"
tags: ["Extensions","Datenbank","Frage","Powermail"]
created: "2015-03-24"
last_reply: "2015-03-25"
replies: 2
solved: false
page: 1
pages: 1
lang: "de"
---

# Powermail dropdown ergebnis in fremde Tabelle schreiben

Extensions · 2 Antworten · gestartet 2015-03-24

## Eröffnungsbeitrag

**mchenzi** · 2015-03-24 · [Beitrag #1](https://www.typo3.net/d/119958-powermail-dropdown-ergebnis-in-fremde-tabelle-schreiben/1)

Hallo
Habe folgendes.... Ausgeben ins Dropdown Feld geht aber speichern geht nicht

```typoscript
# Choose Category from Table
lib.category = COA
lib.category {
10 = TEXT
10.value = <label for="powermail_field_certified" class="powermail_label" title="">Category</label>
20 = CONTENT
20.wrap = <select class="form-control powermail_select" id="category" name="tx_powermail_pi1[category]" size="1">|</select>
20 {
table = tx_ososeamaerketplace_domain_model_producetype
select.pidInList = 43
select = orderBy = produce_category
renderObj = COA
renderObj {
10 = COA
10{
10 = TEXT
10 {
field = uid
wrap = <option value="|">
}
20 = TEXT
20 {
field = produce_category
wrap = |</option>
}
}
}
}
}
```

Nur das speichern geht nicht

```typoscript
plugin.tx_powermail.settings.setup.dbEntry.tx_ososeamaerketplace_domain_model_selling{
_enable = TEXT
_enable.value = 1
pid = TEXT
pid.value = 43

tstamp = TEXT
tstamp.data = date:U
produce = TEXT
produce.field = produce
category = TEXT
category.data = TSFE:tx_ososeamaerketplace_domain_model_producetype|sesData|powermail_2|uid2
}
```

powermail_2 die ID des Content Elements ist 2 und uid2 das ist das Feld in POwermail

## Antworten

### [#2](https://www.typo3.net/d/119958-powermail-dropdown-ergebnis-in-fremde-tabelle-schreiben/2) · einpraegsam.​net · 2015-03-25

Ich würde ein Feld vom Typ Select erstellen, die Optionen leer lassen und "create from typoscript" nutzen - siehe:
<http://docs.typo3.org/typo3cms/extensions/powermail/ForEditors/AddANewForm/FieldSelect/Index.html>

Dies geht aber der Version 2.1

### [#3](https://www.typo3.net/d/119958-powermail-dropdown-ergebnis-in-fremde-tabelle-schreiben/3) · mchenzi · 2015-03-25

Habe es dann doch gelöst....
HIer wird das Feld erstellt

```typoscript
# Choose Category from Table 
    lib.producecategory = COA
    lib.producecategory {
    		10 = TEXT
    		10.value = <label for="powermail_field_producecategory" name="tx_powermail_pi1[field][producecategory]" class="powermail_label" title="">Category</label>
    		20 = CONTENT
    		20.wrap = <select class="form-control powermail_select" id="producecategory" name="tx_powermail_pi1[field][producecategory]" size="1">|</select>
    		20 {
    			table = tx_ososeamaerketplace_domain_model_producecategory
    			select.pidInList = 43
    			select = orderBy = producecategory
    			renderObj = COA
    			renderObj {
    				10 = COA
    				10{
    					10 = TEXT
                                10 {
                                        field = uid
                                        wrap = <option value="|">
                                }
                        20 = TEXT
                        20 {
                                        field = producecategory
                                        wrap = |</option>
                                }
    				}
    			}
    		}
    }
```

Hier die userFunc

```php
<?php
class user_ososea_func {
    public function implodeProduceCategory() {          
        $cats = $_POST['tx_powermail_pi1']['field']['producecategory'];
        return $cats;
    }
}
?>
```

und hier das schreiben in die DB

```typoscript
includeLibs.user_ososea_func = fileadmin/09_ts/user_ososea_func.php 
plugin.tx_powermail.settings.setup.dbEntry.tx_ososeamaerketplace_domain_model_selling{
            _enable = TEXT
            _enable.value = 1
            pid = TEXT
            pid.value = 43     
            tstamp = TEXT
            tstamp.data = date:U
            produce = TEXT
            produce.field = produce     
            producecategory = TEXT
	    producecategory {
	          preUserFunc = user_ososea_func->implodeProduceCategory
	        }
            description = TEXT
            description.field = description  
            location = TEXT
            location.field = location     
            amount = TEXT
            amount.field = amount
            until = TEXT
            until.field = until
            price = TEXT
            price.field = price  
            contactperson = TEXT
            contactperson.field = contactperson 
            contactemail = TEXT
            contactemail.field = contactemail   
            image = TEXT
            image.field = image
            feuser = TEXT
            feuser.data = TSFE:fe_user|user|uid
}
```

Also das geht jetzt.

Für die nachwelt. Also for the english community if you want to write into DB powermail userfunction select field external Table with Relation.

---

Quelle: „Powermail dropdown ergebnis in fremde Tabelle schreiben“, typo3.net, https://www.typo3.net/d/119958-powermail-dropdown-ergebnis-in-fremde-tabelle-schreiben
Beiträge von Mitgliedern des Forums. Bitte mit Link auf die Diskussion zitieren.
