How to Edit data and Save in google sheet by Action

I have google sheet data. And i want to edit data, how to edit data and save by Action in Flipabit?

First check this video Create a Shopping App from Google Sheets | Flipabit - YouTube

You can connect a text field to the table in the same way as in the video. To write the changed value just call the action Change current field.

image

In the example from the video, I converted the title text widget into a text field.

image

And added a save button that writes the changed value to the table.

image

See the example vinyl_app_edit.pma (58.2 KB)

You need to use your credentials:

image

Wow, Many Thanks for your help.

if i want to change more fields, examples " Title" and " Dercripstion". How to use " Action"?.

change

It is not working

It really doesn’t work and we will improve it in the next version.

This is because the actions are performed asynchronously and the save of the first field causes a data change signal, and the second field updates its value and the entered changes are discarded.

As a workaround, you need to use a helper string for each field you plan to modify.

image

Here is the example project vinyl_app_edit_multiple.pma (58.8 KB)

Another way is to create a Json string with all the required fields. And then commit all changes in one step.

image

To do this, you need to use a template string:
image

Here is the example project vinyl_app_edit_multiple_json.pma (58.8 KB)

1 Like

Working perfect. Thanks your help!

after adding a new (text) input field, bind it to a data-column, the correct value is displayed.
But when I click in that field (to edit), the contect disappears and I only get a blank (input-)field.
Where do I have to change a setting?

And if possible an example pma-file with all the actions needed to add a record with multiple fields (input widgets) to Google Sheet.
Thanks !

To save multiple fields in the database at the same time, do the following:

  1. Add a Query begin action
  2. Add a Query field action for each field you want to save. Specify the field name and value as arguments.
  3. Add a Query end action that saves all fields.

image

Here is an exmple save_multiple_database_fields.pma (19.5 KB)

Has someone any suggestions for my problem :

after adding a new (text) input field, bind it to a data-column, the correct value is displayed.
But when I click in that field (to edit), the contect disappears and I only get a blank (input-)field.
Where do I have to change a setting?

Maybe you have set event to changed

Could you share your project. I’ll check it. It will be useful if you record a video with an error.


Back to Flipabit >
Copyright © 2018. Flipabit Team. All rights reserved.