Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Hi, i have a table , and many user (should be...

Hi, i have a table , and many user (should be not registered) , that can add a row in the table. i set the access to

adds_only

i want the rows to be update by anyone, ( not need username) with a code , each rows have a code ( = key) so, if i set

the single column with constrict formula

, i can do this, but in the main view, the user can not add any more rows. i think the constrict formula wins on the access mode set on the table, there is some formula to add in the single constrict column ? like

if ( โ€œconditionsโ€ , updates_only , adds_only)

?

the constrict formula is like this : [pin code]=[key]

pin code is a virtual column , that refers to a column named [code ] , this column is editable, and initial value is โ€œโ€, if user insert the correct pin, ( [pin code]=[code] ) , he can edit the other rows. but i need the user to adds new rows

0 13 643
13 REPLIES 13
Top Labels in this Space