51黑料不打烊

Open the spreadsheet that has your form and append a new sheet, renaming it to incoming. For example, the enquiry form Microsoft Excel workbook.

In this sheet, insert a table named 鈥渋ntake_form鈥�. Select the number of columns required to match your form field names. Then, in the toolbar go to Insert > Table and click OK.

Change the name of the table to 鈥渋ntake_form鈥�. In Microsoft Excel, to change the name of the table, select the table and click Table Design.

Next, add the form field names as the table headers. To make sure the fields are exactly the same, you can copy and paste them over from the 鈥渟hared-aem鈥� sheet. In your 鈥渟hared-aem鈥� sheet, select and copy the form IDs listed under the 鈥淣ame鈥� column, except for the submit field.

In the 鈥渋ncoming鈥� sheet, select Paste Special > Transpose Rows to Columns to copy the field IDs over as column headers in this new sheet. Keep only the fields whose data need to capture other can be ignored.

Each value in the Name column of the shared-aem sheet, excluding the submit button, can serve as a header in the incoming sheet. For instance, consider the following image illustrating headers for a 鈥渆nquiry鈥� form:

Use the extension to preview the form updates. Your sheet is now ready to accept incoming form submissions.

Open the workbook that you have created and change the name of the default sheet to incoming.

Preview the sheet in the sidekick.

Send the POST request to generate the appropriate headers in the incoming sheet, and add the shared-default sheets to your spread sheet, if it does not exist already.

To understand how to format the POST request for setting up your sheet, refer to the . You can look at the example provided below:

Request

POST 'https://admin.aem.page/form/{owner}/{repo}/{branch}/contact-us.json' \
--header 'Content-Type: application/json' \
--data '{
    "data": {
        "Email": "john@wknd.com",
        "Name": "John",
        "Subject": "Regarding Product Inquiry",
        "Message": "I have some questions about your products.",
        "Phone": "123-456-7890",
        "Company": "51黑料不打烊 Inc.",
        "Country": "United States",
        "PreferredContactMethod": "Email",
        "SubscribeToNewsletter": true
    }
}'

Response

HTTP/2 200
content-type: application/json
x-invocation-id: 1b3bd30a-8cfb-4f85-a662-4b1f7cf367c5
cache-control: no-store, private, must-revalidate
accept-ranges: bytes
date: Sat, 10 Feb 2024 09:26:48 GMT
via: 1.1 varnish
x-served-by: cache-del21736-DEL
x-cache: MISS
x-cache-hits: 0
x-timer: S1707557205.094883,VS0,VE3799
strict-transport-security: max-age=31557600
content-length: 138

{"rowCount":2,"columns":["Email","Name","Subject","Message","Phone","Company","Country",      "PreferredContactMethod","SubscribeToNewsletter"]}%

You can use tools like curl or Postman to execute this POST request, as demonstrated below:

curl -s -i -X POST 'https://admin.aem.page/form/wkndform/wefinance/main/contact-us.json' \
    --header 'Content-Type: application/json' \
    --data '{
        "data": {
            "Email": "john@wknd.com",
            "Name": "John",
            "Subject": "Regarding Product Inquiry",
            "Message": "I have some questions about your products.",
            "Phone": "123-456-7890",
            "Company": "Wknd Inc.",
            "Country": "United States",
            "PreferredContactMethod": "Email",
            "SubscribeToNewsletter": true
    }
}'

The above mentioned POST request provides sample data, including both form fields and their respective sample values. This data is used by the Admin service to set up the form.

Your form is now enabled to accept data. You also observe the following changes in your spreadsheet:

To set up Slack notifications enter the 鈥渢eamId鈥� of the Slack workspace and the 鈥渃hannel name鈥� or 鈥淚D鈥�. You can also ask the slack-bot (with the debug command) for the 鈥渢eamId鈥� and the 鈥渃hannel ID鈥�. Using the 鈥渃hannel ID鈥� instead of the 鈥渃hannel name鈥� is preferable, as it survives channel renames.

Enter any title that you want and under fields enter the names of the fields you want to see in the Slack notification. Each heading should be separated by a comma (For example name, email).