Unable to add row to big query table

[Nielay]

Hello All,

I have my data source in big query and when fill my form and click on submit it gives an error saying-

please suggest solution for this.

[SkrOYC]

I don't use BigQuery but the error seems straighfoward.
Please share your schema in order to help.

Can you check the docs if there is any limit related to BigQuery that you are not aware of?

[Nielay]

The documentation says that they have added CRUD operations, so that shouldn't be an issue.

All the column fields are string type

[Steve]

Make sure every column that is required to have a value has a non-blank value.

[Nielay]

Yes, I have done that, if the necessary input field are not filled the form will give error

[Steve]

---

@Nielay wrote:

if the necessary input field are not filled the form will give error

---

Possible you have fields in the BQ table that are required but not also required in the form?

[Nielay · Accepted solution]

Identified the problem: It was the system-generated virtual columns that were causing the Dbnull error. A workaround I found is to split the form into 2-3 views with different data tables.