Is it Possible to Have a Form Pull From a Summary Field on the Sheet?

Sarah123

I believe I've seen that this isn't possible but wanted to check if anything has changed or if someone came up with a solution.

I have a form where people sign up for a tour. In the main sheet I use the Sheet Summary to keep track of how many spots are left for the tour. I would like to pull from this Sheet Summary field into the form so that I don't have to go in and update it each time someone signs up. Right now I just use a text box that I update manually with the number of spots remaining.

Andrée Starå

Is it Possible to Have a Form Pull From a Summary Field on the Sheet?

Sarah123

Dec 9, 2024

I believe I've seen that this isn't possible but wanted to check if anything has changed or if someone came up with a solution.

I have a form where people sign up for a tour. In the main sheet I use the Sheet Summary to keep track of how many spots are left for the tour. I would like to pull from this Sheet Summary field into the form so that I don't have to go in and update it each time someone signs up. Right now I just use a text box that I update manually with the number of spots remaining.

---

View Post

Hi,

I hope you're well and safe!

Unfortunately, no. But you could add the form on one side in a Dashboard and then the counter or something on the other.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Andrée Starå

Is it Possible to Have a Form Pull From a Summary Field on the Sheet?

Sarah123

Dec 9, 2024

I believe I've seen that this isn't possible but wanted to check if anything has changed or if someone came up with a solution.

I have a form where people sign up for a tour. In the main sheet I use the Sheet Summary to keep track of how many spots are left for the tour. I would like to pull from this Sheet Summary field into the form so that I don't have to go in and update it each time someone signs up. Right now I just use a text box that I update manually with the number of spots remaining.

---

View Post

Hi,

I hope you're well and safe!

Unfortunately, no. But you could add the form on one side in a Dashboard and then the counter or something on the other.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Sarah123

Thank you @andree stara! I will have to try that out but I think that is a solution I can use.