Can I change and save the text stored in the database that I see in a text box? But the text field is in the Views tab in a table.

Update text in a database table displayed within a CF form's Views tab.

Overview

The form's update function was not correctly configured to process the edited text field data.
Ensure the loop function in the Events tab properly triggers the save action and that the update conditions in the Functions tab correctly match the database record.

Answered
Connectivity v6
Fr Fredolino 22 Nov, 2019
Can I change and save the text stored in the database that I see in a text box? But the text field is in the Views tab in a table.

Here's the data. But it does not work:

In Views-Tab i have one Table "table_fotos".

Data provider: {var:read_fotogalery}
Columns list:
fotogalery.bilddaten:Bilddaten
bilddaten_edit:Edit Bilddaten
speichern:speichern
Columns views:
bilddaten_edit:{view:foto_bilddaten_list_field}
speichern:{view:button_speichern}
and this Text-Field: "foto_bilddaten_list_field"
Name:
bilddaten[{var:table_fotos.row.fotogalery.foto_id}]
Value:
{var:table_fotos.row.fotogalery.bilddaten}


Under the Functions-Tab
Loop: save_foto_bilddaten_loop
Data provider: {data:bilddaten}
Loop body: {fn:update_foto_bilddaten}
and Save Data: : update_foto_bilddaten
Write action: Auto detect
Model: fotogalery
Database table: mytable
Data provider: empty
Data overrides
bilddaten / {var:save_foto_bilddaten_loop.row} / one update
Update conditions
foto_id = {var:save_foto_bilddaten_loop.key} / Use

Under the Events-Tab: update_list
Content:
{fn:save_foto_bilddaten_loop}
{redirect:index}

F.Can I change and save the text stored in the database that I see in a text box? But the text field is in the Views tab in a table. image 1
This topic is locked and no more replies can be posted.