Column formula - can you use in a form?

MichelleBohn

In a form can you add in a column formula as an option to show up on a form? I don't think so because I don't see it as one of the fields to choose from when building the form.

I was wondering if anyone knows of a workaround? What I'm trying to accomplish is if the user selects a certain location, the financial fields will auto-fill on the form as it does on the sheet in the background. This way they can make sure they selected the right location from the dropdown.

Andrée Starå

Hi @MichelleBohn

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Multiple so-called helper columns combined with the Form Logic feature and Default Value.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community 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!

MichelleBohn

@Andree Stara - thank you for your response, I will submit the idea.

Not sure the workaround you mentioned will work? What I told them for now was after they submit the request with the location all the financial fields that have the column formulas will be included in the email they receive. It won't be real-time in the form it itself but if they find a mistake in the email,I created a 'Dynamic View' for them to update the information there. A few extra steps for the submitter but it will work for now.

Thanks again!