This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

increment field in BigQuery for an Appsheet app which uses as Data Source bigquery tables

Posted on 07-08-2024 03:06 AM
Ruxandra
Bronze 4
Bronze 4
Reply posted on --/--/---- --:-- AM

Hello!

I have an app created in Appsheet, using as Data Source Bigquery's tables. I need a field in order to have an incremental series for user reports.

Appsheet doesn't have an autoincrementing field; if I use Max() +1 , it is not ok because, if several users click on "Save" button at the same time, we will have duplicates of number, for example, if the last number is 5 and 3 users save their report at the same time, we will have 3 new records with the number =6 instead of 3 new records number 6,7,8.

Could anyone help me by giving me an idea what should I do in Bigquery in order to obtain an incremental field when a new record is created in the bq table?

Thank you!

Regards!

Ruxandra

p.s. I am not allowed to use a Sql Db.

 

 

1 1 774
Topic Labels
Reply
1 REPLY 1