Auto populate based on USEREMAIL()

Hi,

I have tables with USEREMAIL() in [User Id] Columns. This is used to retrict and direct the user to the correct view. Is it possible for appsheet to autocreate a new row in a table based on the fact that a new user has been created. This would mean they wouldnโ€™t have to create one themselves.

Below is the table that a user can input various criteria. There are actions buttons to link to a view based on a slice based on the conditions they have set. To stop muliple users interfereing with each others inputs they can only view and manipulate the row with their USEREMAIL() in.

I tried adding an action button to create a new row with their useremail but the bitton wonโ€™t appear unless there is a row to show - which there isnโ€™t becasue their useremail isnโ€™t there yet.

Thanks

Phil

Unique ID County Price List Outlet Rating Outlet Type User Id
1 Cheshire , Cumbria , Lancashire , Merseyside , North Yorkshire , West Yorkshire Band 1 , Band 2 , Band 3 , Band 4 , Custom Check Festival , 0 , Social Club , Individual , Free , Pub , Micropub , Club , Off Licence , Bar , Hotel Bar , Sports Club , Event , Other , Caterer , Shop , Restaurant hilary@listersbrewery.com
2 Cheshire , Cumbria , Lancashire , Merseyside , North Yorkshire , West Yorkshire Band 1 , Band 2 , Band 3 , Band 4 , Custom Prospect with contact made Festival , 0 , Social Club , Individual , Free , Pub , Micropub , Club , Off Licence , Bar , Hotel Bar , Sports Club , Event , Other , Caterer , Shop , Restaurant phil@listersbrewery.com
0 11 1,850
11 REPLIES 11
Top Labels in this Space