@Scott_Nesbitt Note that using Bigquery, the data is read only as you are just reading and not writing back. Having an initial value of anysort, is likely not going to work. The only value you can control will be creating virtual columns.
As for the key going back to _RowNumber. Check the data type in Appsheet. An anomoly occurs with the first import from Bigquery being all strings turn into LongText. If you try having that as a key, it will be rejected. You have to change the LongText into just Text. I do this for ALL columns that fall into LongText. I don't know if it matters, but ususally data handling and performance are impacted in most data systems for varchar or blobs. Better safe in my opinion.
If someone from Appsheet team can answer this, it would help better understand.
LinkedIn
Twitter
