Add rows using Appsheet API with a virtual column that has ref_rows to another table

[ralph.christian]

I have a parent database that has a required virtual column that supposedly connect it to a child database.

When calling the Appsheet API, I am getting this error:

Response: {“type”:“RFC 9110 - HTTP Semantics Request”,“status”:400,“detail”:“REST API invoke request failed: Error: Can’t add or update a row because a required value is missing. Provide the required value and try again.\n\n\tRow ID to correct: 3b39a8c7.\n\tMissing value in column: Related table_column_access_requests”,“traceId”:“00-4bccc89bd1c5a2f399fa6116a7310670-3bf7c28ab77dd353-00”}

Where Related table_column_access_requests is the virtual column.

The app formula for Related table_column_access_requests is **REF_ROWS(“Requestor”, “Parent”)
**
where Requestor is a slice in the child database, and Parent is the column where Parent Primary Key is stored

[AleksiAlkio]

Your virtual column doesn’t need to be “required” as the result is calculated automatically with the app formula. Remove that option and see does it work then.

[ralph.christian]

This worked for now; Thank you!

However, we intended to have that column be required because we do not want a customer to be able to create a ticket without the child requests if this Related table_column_access_requests is not required.

Are there other solutions for this?

[AleksiAlkio]

One option is to use expression CONTEXT(“Host”)<>”Server” with the “Require?” so it’s not required column in the server side where the webhook is triggered.