# Business Forms : read only **URL:** \ **Category:** Grafana\ **Tags:** business-forms, plugins\ **Created:** [February 20, 2025, 10:31am UTC](https://community.grafana.com/t/business-forms-read-only/144473 "2025-02-20T10:31:03Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 20, 2025, 10:31am UTC](https://community.grafana.com/t/business-forms-read-only/144473/1 "2025-02-20T10:31:03Z")
Hello everyone, I’m facing some issues with the “read only” type of element in the Business Forms. As you can see below, the element “ID” is set as a “read only” type and linked o a query. ![Capture d'écran 2025-02-20 112255](https://us1.discourse-cdn.com/grafana/original/3X/9/8/98262d141331e75ed4d7ad9b40d585da79707dad.png) So I’m supposed to see the value of “ID” on the panel, but there is only a grey rectangle and nothing else is shown as showed below. ![image](https://us1.discourse-cdn.com/grafana/original/3X/3/8/386e605b7a896af9cced1e9d4610b4ead124eaa5.png) Can someone explain why it’s doing that or what I’m doing wrong ? ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 20, 2025, 1:59pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/2 "2025-02-20T13:59:33Z")
Hi LeaneM, when you configured a field as Read-only. You have to fill it in the “Initial Fields” section. That does the trick. Jo ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 20, 2025, 4:20pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/3 "2025-02-20T16:20:45Z")
Hi joachimschiewek, I appreciate your help, I noticed you had posted a similar issue some years ago. What exactly should be detailed in the “Initial Fields” ? I don’t get what type or what kind of writing is expected. Thanks in advance ! Leane ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 21, 2025, 8:16am UTC](https://community.grafana.com/t/business-forms-read-only/144473/4 "2025-02-21T08:16:41Z")
If you have selected the query as the source, then in your case the result of query “A” from the “id” column must be in the Value Fields field. So, Value Field:A:id Thats what you have done. Now you will also find the field “ID” created in this way under the tab “Initial Fields - Query Fields”. The query field “A:ID” is now there. Select the result of the query again, i.e. A:id. The value should then appear in gray in the form field ID. Jo ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 21, 2025, 8:38am UTC](https://community.grafana.com/t/business-forms-read-only/144473/5 "2025-02-21T08:38:36Z")
[https://volkovlabs.io/plugins/business-forms/elements/read-only/](https://volkovlabs.io/plugins/business-forms/elements/read-only/) ![image](https://us1.discourse-cdn.com/grafana/original/3X/d/2/d244555d02bb29d94e6ac3034664c1b55f8fdd00.png) ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 21, 2025, 9:23am UTC](https://community.grafana.com/t/business-forms-read-only/144473/6 "2025-02-21T09:23:48Z")
Okay so I got your explanation. The field “ID” is created under the tab “Initial Fields” as you explained. So I specified the name as you can see in the image below, as I couldn’t select anything. ![image](https://us1.discourse-cdn.com/grafana/original/3X/c/b/cb8f659a123fb22dbc183c988b331a601ecfca0d.png) Now the issue persist as noting is shown… You may have other infos or ideas, feel free to share and thanks in advance ! Leane ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 21, 2025, 10:31am UTC](https://community.grafana.com/t/business-forms-read-only/144473/7 "2025-02-21T10:31:42Z")
…does the “Table View” display the result of your query? (Query A) ![image](https://us1.discourse-cdn.com/grafana/original/3X/6/7/671d5c2613da94aaba8482b88be7f395bd037196.png) and wich version of the BusinessForms Plugin do you have installed? there was an error in an older version. ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 21, 2025, 10:46am UTC](https://community.grafana.com/t/business-forms-read-only/144473/8 "2025-02-21T10:46:14Z")
Yes, the “Table View” does display the value of my query as shown below. ![image](https://us1.discourse-cdn.com/grafana/original/3X/6/e/6eeadccb8cc6fccf8b2c28bbcccb02404d6dfccd.png) The version of the Business Forms plugin is 4.7.0, what do you think ? ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 21, 2025, 11:35am UTC](https://community.grafana.com/t/business-forms-read-only/144473/9 "2025-02-21T11:35:08Z")
hmm… I have absolutely no idea. I use version 4.9 And the Initial Fiels is showen as: ![image](https://us1.discourse-cdn.com/grafana/original/3X/9/4/94dec5a71f4fb5ec4e0c4258539cda5ea8ec21d6.png) but it can’t be that… I’m at a loss, so sorry ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 21, 2025, 2:18pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/10 "2025-02-21T14:18:28Z")
Thanks already for your help since the start !! I will make sure to have a more recent version then and try again what you explained earlier. ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 21, 2025, 2:50pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/11 "2025-02-21T14:50:19Z")
I found the root of this issue, under the tab “Initial Request” and by “Initial Action” I had chosen something else than “Query” which is necessary to be able to select the query for each element !!! It works better haha, now I need to dig into how to write the request to update my database. ---
**Author:** ![mikhailvolkov](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/mikhailvolkov/32/41625_2.png) [@mikhailvolkov](https://community.grafana.com/u/mikhailvolkov)\ **Post date:** [February 23, 2025, 4:20pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/12 "2025-02-23T16:20:28Z")
@LeaneM Let us know if something is not clear in the documentation for the Business Forms panel, we constantly improving it based on the Community feedback. ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 24, 2025, 6:37am UTC](https://community.grafana.com/t/business-forms-read-only/144473/13 "2025-02-24T06:37:19Z")
We finaly found it in the end… 😅 👍 Remember, if you have read-only elements, you have to select “All Elements” for the Update Request Payload - Request Payload. Then you can use the Read-Only-Element in the update query. Jo ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 24, 2025, 10:56am UTC](https://community.grafana.com/t/business-forms-read-only/144473/14 "2025-02-24T10:56:54Z")
Hi @mikhailvolkov well for the “Update Request” part on the documentation, I’m having some trouble to understand exactly what is needed. I tried something as you can see below. I underlined in **green** the **database** name and in **pink** the name of the **table**. ![image](https://us1.discourse-cdn.com/grafana/original/3X/1/5/157793ed0b2617301a7b4226b6e69face9ee947a.png) The goal here is to update the value of “NOM” in the table by entering a value to the variable “NOM1” thanks to the Business Forms. I’m acually lost at what to specify at the “Update Request”. In addition to this an error is showing : ![image](https://us1.discourse-cdn.com/grafana/original/3X/7/5/754821309a7a6ad21d255d0450a114d28dc55dba.png) If you could help me finding what is wrong or what needs to be added, it would be gladly appreciated. ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 24, 2025, 11:04am UTC](https://community.grafana.com/t/business-forms-read-only/144473/15 "2025-02-24T11:04:15Z")
Thank you for reminding me !! By doing this where do I write the code to update the table ? Leane ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 24, 2025, 11:46am UTC](https://community.grafana.com/t/business-forms-read-only/144473/16 "2025-02-24T11:46:00Z")
As I wrote… when you use a READ-Only\_Element as Variable you have to chose “All Elements” ![image](https://us1.discourse-cdn.com/grafana/original/3X/5/4/5431c69cb356ac88e009377dfe2b3fcb8eed15b0.png) You don’t need to change anything in the “Create Payload” section. You can write your Query in the “Query Editor” section in normal way. Example ![image](https://us1.discourse-cdn.com/grafana/original/3X/4/9/4969193d7081d471798fbdc7848eae6da406cb63.png) Hope that helps you ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 24, 2025, 12:49pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/17 "2025-02-24T12:49:10Z")
My apologies, I didn’t quite follow your insrtuctions, will do now ! So after specifying the “All Elements” and not changing anything to the “Create Payload” section, I then wrote in the query editor what I want to do, as you can see on the image below. ![Capture d'écran 2025-02-24 133532](https://us1.discourse-cdn.com/grafana/original/3X/d/b/db8c68756c63a984e96a50f3c17cefba31d4b0b1.png) I can achieve to write on a table of my database, however it writes "${payload.NOM1} instead of the name of the variable “NOM1” specified by the user in the Business Forms … ![image](https://us1.discourse-cdn.com/grafana/original/3X/6/0/6052ef33ffce21945e0b88fe5b771423dc308215.png) Do you have any idea of where the issue comes from ? ---
**Author:** ![joachimschiewek](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/joachimschiewek/32/38184_2.png) [@joachimschiewek](https://community.grafana.com/u/joachimschiewek)\ **Post date:** [February 24, 2025, 1:45pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/18 "2025-02-24T13:45:14Z")
Ok… you have a Form Element with Id: “NOM1” ? and it is filled with a value? Are you able to check in the Browser development tool which rawSql is in the payload? ---
**Author:** ![LeaneM](https://avatars.discourse-cdn.com/v4/letter/l/ecccb3/32.png) [@LeaneM](https://community.grafana.com/u/LeaneM)\ **Post date:** [February 24, 2025, 4:00pm UTC](https://community.grafana.com/t/business-forms-read-only/144473/19 "2025-02-24T16:00:01Z")
Yes I do, and you don’t have to search no more 🙂 It was a silly mistake that I made while writing the MySQL request… I can now achieve to update the table I want with the value I enter in the Business Forms. Thank you again !! You will probably see me around haha !