Skip to content
callin.io Form data...
 
Notifications
Clear all

callin.io Form data to google sheet

6 Posts
3 Users
0 Reactions
4 Views
Steve_Warburton
(@steve_warburton)
Posts: 3
Active Member
Topic starter
 

Information on your callin.io setup

  • callin.io version: 1.77.0
  • Database (default: SQLite):SQLite
  • callin.io EXECUTIONS_PROCESS setting (default: own, main):default
  • Running callin.io via (Docker, npm, callin.io cloud, desktop app):npm
  • Operating system:Win 10

I am testing a basic form entry and inputting into google sheet.

I have the main document with

A1 = Company Name
B1 = Contact

When I run the workflow I am expecting the workflow to add a new sheet ( which it does ) then add the data ie company name & contact

But I get:

spreadsheetId sheetId title index sheetType gridProperties
1o_JrpYAMYKYFve9tW8j41ubc9pUQsg-qRLOquJkIg7w 1373677401 234 5 GRID {rowCount:1000,columnCount:26}

What am I not understanding here please?

 
Posted : 14/02/2025 12:22 pm
Milan_AutomableAI
(@milan_automableai)
Posts: 4
New Member
 

In your second Sheets operation, you are attempting to add the Company Name and Contact to a sheet that was just created and is currently empty.

If you wish to accomplish this, you can do so as demonstrated below using an Edit Fields node.

Alternatively, you can specify the Sheet as your first sheet, rather than the newly created _Client Name_ sheet.

 
Posted : 14/02/2025 1:20 pm
Steve_Warburton
(@steve_warburton)
Posts: 3
Active Member
Topic starter
 

Excellent, I appreciate the assistance.

Is it possible to customize the forms?

For instance, can I add a company logo, branding, or specific colors?

 
Posted : 14/02/2025 3:25 pm
Milan_AutomableAI
(@milan_automableai)
Posts: 4
New Member
 

Glad to assist!

:slight_smile:

You can incorporate HTML into the form description, which allows for the inclusion of elements like a logo.

  • Milan, Consultant @ Automable.ai
 
Posted : 14/02/2025 3:39 pm
Steve_Warburton
(@steve_warburton)
Posts: 3
Active Member
Topic starter
 

For anyone else who might need this:

On the form submission, I utilized:

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
</head>
<body>
  <center>
    <img src="https://wilsea.com/pickandship.co.uk/logo1.png" alt="Pick And Ship Logo" width="200">
  </center>
</body>
</html>

On the form itself, I used:

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>Pick And Ship Customer Enrollment</title>
  <style>
    body {
      font-family: Arial, sans-serif;
      text-align: center;
      margin-top: 0;
    }
    h1 {
      margin-top: 20px;
    }
    img {
      display: block;
      margin: 0 auto;
      width: 120px;
    }
  </style>
</head>
<body>
  <img src="https://wilsea.com/pickandship.co.uk/logo1.png" alt="Pick And Ship Logo">
  <h1>Pick And Ship Customer Enrolment</h1>
</body>
</html>

Is there a way to alter the color of the default orange buttons?

 
Posted : 14/02/2025 6:43 pm
system
(@system)
Posts: 332
Reputable Member
 

This thread was automatically closed 90 days following the last response. New replies are no longer permitted.

 
Posted : 15/05/2025 6:43 pm
Share: