Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

how can I create a form for entering data into a spreadsheet

how can I create a form for entering data into a spreadsheet


Posted on Oct 10, 2021 2:05 PM

Reply
2 replies

Oct 10, 2021 6:57 PM in response to pspd1968

It could be done with an Applescript designed specifically for your purpose. Your "form" would be a sheet with a table or set of tables and you would use a keyboard shortcut to submit the "form" to your "spreadsheet" table. The keyboard shortcut would invoke the Applescript to transfer the data and clear the "form" for the next entry.


If the "form" is limited to one table, it might be possible to create a more generic Applescript but it would take some work to write it. I am thinking it would involve a second table that tells the script where to submit the data (i.e., which column of the specified sheet::table) for each cell of the form.

how can I create a form for entering data into a spreadsheet

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.