Unchanged dropdowns in popup updating as empty in the database

priyanka.vijayakumar · 2024-09-25T12:57:34.069Z

Hi all,

I have a table that shows a weekly meal plan on a page with an edit button on each row. The edit button opens a popup with a dropdown corresponding to each meal in a single day. If I don’t make any changes to a field, and save it (using the workflow action make changes to a thing), it saves an empty value in the database. It should ideally make changes to only thosew entries that have changed. Looking for some smart way to fix this issue.

Screenshot 2024-09-25 at 12.56.54 PM1164×1386 76.2 KB

Screenshot 2024-09-25 at 1.15.26 PM2060×282 38.7 KB

Screenshot 2024-09-25 at 1.15.53 PM1728×1376 293 KB

Screenshot 2024-09-25 at 1.17.07 PM1158×1082 128 KB

I have to edit the entire row because if I add the edit functionality to each cell to edit the entry inline, the entire column gets impacted.

Screenshot 2024-09-25 at 1.22.35 PM2032×272 32.7 KB

Am i doing something wrong? Is there a better way of doing this?

Thanks in advance!

tunacardak · 2024-09-25T14:36:34.488Z

I can check the problem quickly if you can share the app.

priyanka.vijayakumar · 2024-09-26T03:24:58.008Z

Sure I am sending it over to you. Thanks so much for offering!

tunacardak · 2024-09-26T07:16:39.441Z

Sure. Can I ask where you show this table?

image1054×131 19.6 KB

ntabs · 2024-09-26T07:33:28.580Z

priyanka.vijayakumar:

It should ideally make changes to only thosew entries that have changed.

In your action, you must’ve added the field with an empty value. Only make changes to a field that you’re changing

I’m positive this is how your action looks like:

Make changes to thing action

field 1 = new value
field 2 = new value
field 3 = empty
field 4 = new value

if you’re only changing the values for field 1, 2, and 4, you must not add field 3.

If you want to change multiple fields in one action, you can add a default data source of the inputs referencing to its value and on your action simply reference to all the corresponding inputs

Let me know if this helps

priyanka.vijayakumar · 2024-09-27T06:38:51.533Z

ntabs:

If you want to change multiple fields in one action, you can add a default data source of the inputs referencing to its value and on your action simply reference to all the corresponding inputs

By this, do you mean that I should set states instead of getting the value from a dropdown directly into the database? Because I have set a default value - on each dropdown.

Thank you for taking the time! I am playing around with auto-binding now (I am not excited about doing this but hey, if it works!)

ntabs · 2024-09-27T06:45:33.276Z

priyanka.vijayakumar:

By this, do you mean that I should set states instead of getting the value from a dropdown directly into the database? Because I have set a default value - on each dropdown.

No, you don’t need to use states. Since you have default values, you can just reference to all inputs/dropdowns so any new and old values would be saved.

priyanka.vijayakumar:

I am playing around with auto-binding now

Autobinding would also be great since you don’t need to have a workflow to update a thing and you could select the field that you only want to update

priyanka.vijayakumar · 2024-09-27T07:48:38.486Z

ntabs:

Since you have default values, you can just reference to all inputs/dropdowns so any new and old values would be saved.

I am not quite sure how to do this. Since the default value is set in the properties, shouldn’t the workflow just pick up the default value if it has been left unchanged? Is there some conditional expression that I need to use in the workflow make changes to thing action while assigning the value?

Auto-binding is working fine, but I am just curious why this is not working.

ntabs · 2024-09-27T07:57:56.713Z

priyanka.vijayakumar:

shouldn’t the workflow just pick up the default value if it has been left unchanged?

If you add the field in the fields that would be changed in an action and leave the source blank, it would then change the existing value to empty like this example:

image618×566 17 KB

In this case, the values of the image and name field would be changed to empty since I haven’t specified a source/value.

priyanka.vijayakumar · 2024-09-27T08:21:33.185Z

I just saw this post - this is in the user-home page under weekly plan.

priyanka.vijayakumar · 2024-09-27T08:24:49.774Z

basically there are six dropdowns giving the user the option to change all the entries in the generated plan of a single day. This is in a popup that comes up when the row edit icon is clicked. If any of the meals are not changed while the user has changed any 1 or more, they feed into the database as empty values, despite me having provided each drop down with a default value.

system · 2024-12-04T12:57:48.200Z

This topic was automatically closed after 70 days. New replies are no longer allowed.