Formidable Forms Community Site

The Community forums are being phased out in favor of a new Slack group.
Add your email address below to get an invitation to join the community slack group

Slack Signup
Newsletter Optin
Help Desk
Subscribe

2 tables: ProjectIdeas + ProjectVotes

Labels

This Discussion is public

Notifications

Hi - just wondering if I miss something obvious. I have 2 tables:

ProjectIdeas with Name / DescriptionText
ProjectVotes with StarRating + CommentText + ProjectName (as Lookup Dropdown) + Project Description ( using "Watch Lookup fields")

ProjectIdeas is fine and the ProjectName / Description are on the loaded ProjectVotes form.
However, if I add a new entry to the ProjectVotes table the ProjectName is not part of the data set.
Should I add a hidden field with ProjectIdeaID or do I just miss the obvious?

Thanks,
Olvier

Let me help with something. Just because you have 2 forms, you did not create 2 tables. Formidable follows the WordPress design for data storage. Entries are stored in the frm_items and frm_item_metas tables. All data from form entries are stored in these 2 tables that are core to Formidable.

The frm_items table stores the entry header record, and the actual entry fields are stored in frm_item_metas, one row per field per entry. This is not a standard relational model where tables are linked by primary and foreign keys that allow for cascading events.

If you want to link ProjectIdeas with ProjectVotes, then yes, you have to have a field common to both forms.

Thanks for your comments. Deleting all fields and dropping them again on the form did solve the issue - all good now. Not sure what happened...

Discussion closed.