default formula in hidden field

I need to reference the content from one field in another field on the same row. I want the formula as the Default Value of a hidden field on a form. The formula I'm using is =[Team Member]@row. When a new form is submitted, the field with the formula shows a single quote mark at the beginning, and therefore it's not working.

=[Team Member]@row (default formula in the hidden field)

'=[Team Member]@row (what shows up in the field when the form is submitted)

Any thoughts on how to correct this? Thanks!

Find more posts tagged with

Forms

Formulas

Accepted answers

Monique Odom Stearn

Hello @Amy M. K.,

Is there a specific reason you need this to be a hidden field on the form? If you simply need the information on the row, you can make it a column formula so that it will automatically populate after the form is submitted.

All comments

Monique Odom Stearn

Hello @Amy M. K.,

Amy M. K.

Gah! Totally forgot about column formulas. That worked. Clearly I need more coffee. You're my shero for today!!! Thank you.

Save Draft

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.