I need your help

Anvil Q&A
1

What I’m trying to do:
I try to create warehouse stock card

I get this error:

anvil.server.InternalError: Internal server error: 3bbbdb4f478e

  • at anvil-services/anvil/google/sheets.py:186

how can I correct this error code

2

Welcome to the forum!

It’s impossible to help you without more details.

Please have a look at this and come back with more details: How to ask a good question

4 Likes
3

Sorry,how can I solve this code

anvil.server.InternalError: Internal server error: e2413028ee0b

  • at anvil-services/anvil/google/sheets.py:186
  • called from Receive, line 56
    line 56` ; worksheet.add_row(**data)
4

What if I said “solve it like that, by fixing it”?

I guess you would say you “fixing what? How? I need more details!”

A question without details can only get an answer without details.

5

Hi all,

I’m encountering an error when trying to add a row to my Google Sheet using worksheet.add_row(**data) in Anvil. Here’s the error:
anvil.server.InternalError: Internal server error: a60b4f24eddb
at anvil-services/anvil/google/sheets.py:186
called from Receive, line 56

:bulb: What I’m trying to do:

I’m using app_files.warehouse to access a Google Sheet that I uploaded in Assets > Google Drive > App Files. I want to add form data to a worksheet based on a dropdown selection (self.test_name.text).

:test_tube: What I’ve checked:

  • The worksheet name matches self.test_name.text, and it exists in the Google Sheet.
  • The column headers in the sheet are: วันที่, รายการ, LOT, จำนวน, ผู้ดำเนินการ, หมายเหตุ
  • I used print(data) before calling add_row(), and the data structure looks correct.

Here’s the code causing the error:

data = {
    'วันที่': self.date_box.date,
    'รายการ': 'รับของ',
    'LOT': self.lot_box.selected_value,
    'จำนวน': amount,
    'ผู้ดำเนินการ': self.staff_box.selected_value,
    'หมายเหตุ': self.comment_box.text
}

worksheet = app_files.warehouse.worksheets[self.test_name.text]
worksheet.add_row(**data)  # ← Error happens here

:question:My question:
Is there something else I need to check?
Could this be a formatting issue with one of the fields (like self.date_box.date)?
Or is it possible there’s an issue with permissions or connection to Google Sheets?

Thanks in advance for your help!

sharemy app : Anvil | Login