#In a page from sql DB and I changed some numbers to Selects, but they suddenly became numbers again

1 messages · Page 1 of 1 (latest)

humble crow
#

I create a CRUD page from a mysql table. I change one of the fields in edit and add forms to Select and put some code for it. While I'm editing these suddenly become numbers again. I don't know when, actually, I'm not sure it is somehow connected with using Ctrl+Z. Have you experienced something like this?

strong sapphireBOT
#

Hi There!
Thanks for reaching out to us. One of our engineer will be with you shortly.

If you are stuck with an issue/error, please help us with following information.

  1. Which version of Appsmith are you on?
  2. Provide screenshots/screen recordings of the original error/code snippet.
  3. Add details about your use case and provide steps to reproduce the issue, if
    possible.
humble crow
#
  1. Appsmith Community v1.8.8Released 21 days ago
#

I change this to Select type

#

I change its name

#

I change options to: {{get_servicetypes.data.map(u => ({label: u.name, value: u.id}))}}

#

then I deserlect the selected invoice in the list

#

and when I select it back

#

something happens and my change is not there any more

#

and this happened to my like 20 times in the last 2 months

#

I couldn't understand why it happens

#

today I somewhat have some more info, but not enough

#

The same thing happens with the partner id in the the same form

#

same thing sporadically happens in the other forms as well

#

the app reached a point in which I need to use it, but I'm forced to check the selects if they are working properly, to copy the Options in a separate text file so I can copy-paste them instead of writing them down every time

humble crow
#

Check this video, after I change the numbers to selects I deploy the app

#

and when I refresh it for the first time and select the invoice from the list I see the things I've changed for 1 second and then they become numbers again

#

this is in the deployed app, not in the editor!

strong sapphireBOT
#

Hi! Please disable the Auto Generate form property of the JSON Form if you
don't want to layout to update automatically when the field types inside the
Source Data are changed.

humble crow
#

the field types are not changed during that select/deselect action!

strong sapphireBOT
#

Let me reproduce this and check.

humble crow
#

probably there are some steps which I'm missing which I don't know are related to it

#

I mean that I'm working on that in the last month or so, so probably anything that I did during that period of time could have caused the stars to align in such a way that this is regenerated both in editing mode and in runtime

strong sapphireBOT
#

So you mean that it's turned back to number once you refresh the page or select
a different row in the table?

humble crow
#

I think I've explained it really well. However, to be more specific: while in editing mode if I deselect a table row and select another one it also changes the field type back to number

#

in running mode I found that it is shown as type number, but type Select flashes just for a second after selecting a row for a first time

#

I've shown the running mode (deployed app) in a video I've uploaded

#

after I turned off auto generation it indeed worked and now it is fine, but I doubt that auto generation should work like I explained, seems like a bug to me