About nlozano

nlozano · 10-20-2022

Hi, I was wondering if it's possible to automatically edit/delete a record in a table when another record in a linked table is edited/deleted. We have a Google Calendar table imported and would like to automatically add or update certain events when ...

nlozano · 10-13-2022

Hi, we were wondering if it's possible to restrict the deletion of a row in a table if the id for that row is currently being used by another table that references it, like it would if you set "on delete", "restrict" on a relational database (we're u...

nlozano · 09-30-2022

Hi, I've been testing the BigQuery integration with AppSheet, which since a few months ago it has allowed write access. However, I'm unable to for example create a new item because the datatypes that BigQuery uses aren't the same as the ones that App...

nlozano · 10-27-2022

Has this changed since this was posted? I tried this and it still shows the default inline view from the table in the details, despite having created a table ref view for the slice and having associated the slice in the related column, like REF_ROWS(...

nlozano · 10-26-2022

Okay nevermind, just saw that you need to create a custom action that's specifically "data: set the values of some columns in this row", and then that will show up, but "edit" or other actions don't.

nlozano · 10-26-2022

Thanks for the reply, didn't get back into this until today. On "run action on rows" I can only execute a "delete" action, even though this table has other actions like add, edit and some custom ones I made. Am I missing something?

nlozano · 10-17-2022

Thanks for the response. It's okay, it works fine like this. I just thought hiding the "delete" button without providing a reason why it's hidden could be unintuitive to users, but hopefully it won't be an issue as long as we explain it somewhere.

nlozano · 10-11-2022

Thanks for the responses, in the end the issue was in the BigQuery datatypes and we resolved it.

My Stats

nlozano's Bio

Badges nlozano Earned

Recent Activity

Edit a table when another table is edited

Restrict deletion if referenced id is being used

Datatype incompatibility when inserting data from AppSheet into BigQuery

Re: Edit Inline of a Slice Ref row

Re: Edit a table when another table is edited

Re: Edit a table when another table is edited

Re: Restrict deletion if referenced id is being used

Re: Datatype incompatibility when inserting data from AppSheet into BigQuery