Feature Request: Set and get People chips in Apps Script SpreadsheetApp Class

[Yagisanatode]

Hi All, 

I have sent a feature request to create a Person sub-class to set and get the Person chip information in a Google Sheet with the SpreadsheetApp class. 

My use case is: 

A client has asked that we add the people chips programmatically to a Google Sheet generated from a GWAO and then also be able to read the chip and extract the email address for a user to quickly generate an automated email based on the date in the row.

If you think is a good idea, please support the request by starring it and if you are super passionate about it add your thoughts to the request. 

https://issuetracker.google.com/issues/227926015

Thanks, 

Scott

[Clark Lind]

Once Tables goes live for the whole world, you should have what you need. 

Also, try simply typing the @ symbol inside a cell. You may already have what you need.

[Scott Bennett]

Clark have you heard when tables will go live?  

Scott Bennett

Sent from my iPhone 

On Apr 4, 2022, at 7:05 PM, Clark Lind <cwl...@gmail.com> wrote:

Once Tables goes live for the whole world, you should have what you need. 

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/f2a2c7db-3d56-4a47-bf08-ef91d3ec815en%40googlegroups.com.

[Clark Lind]

Scott, 

The last I saw was "later this year". And that could have been referring to 2021... so..  who knows. 
You can try accessing it here:  https://tables.area120.google.com/

[Clark Lind]

P.S., since it appears you are in the US, you should have access. If you are new to Tables, Ben Collins did a nice overview video here.

[Bennett, Scott]

I have used it in my personal account.  The problem is we want to use it in our school and it is not available for workspace/Enterprise. 

Thanks for info.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/70afbbe2-f1a7-4e08-b99c-e2422491060an%40googlegroups.com.

--

Scott Bennett

Data and Assessment Coordinator/Math Teacher

Bradley-Bourbonnais Community High School

P 815.937.3707 ext. 6010

[Clark Lind]

Your Workspace Admins may have to add it/turn it on, or it may be unavailable right now as Google migrates it (if you weren't already using it). I have access from my Workspace account.