How to create a new record from a parent item and no longer display that parent as an option to prevent duplicates.

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
  • (Edited)
I’m fairly new to QB and have been searching for days so hopefully someone can help.
I have the following tables:
-Customers-
Customer Name
Address
City
State
Zip

-Categories-
Category Name
Category Description

-MyFavorites-
Customer Name (from customers table)
Category Name (from categories table)

-Magazines-
Title
Description
Category (from categories table)
SubMonths
Price

-Orders-
Customer Name (from customers table)
Title (from magazines table)
SubMonths (defaults based on Magazines table BUT can be modified during order)

Basically, a customer can first choose their favorite categories which is recorded into the MyFavorites table. They then go to view each of their favorite categories and see a list of available magazines under each category. My problem is I’m not sure how to remove the magazine title from the list of available magazine once a customer has ordered it. I would also prefer that list of magazines to have a “ORDER” button next to each one that would allow them to modify the number of months they would like that subscription before saving as an order. Help is appreciated!
Photo of Scott Hermanson

Scott Hermanson

  • 90 Points 75 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
I can try to help, but first can you restate your question.  We do not need to know the field list for every table unless it is relevant to the question as that just adds to much mental clutter to posting a clean question.

What would help is to understand the tables and their relationships, ie, which is the One and which is the Many for each relationship.
Photo of Scott Hermanson

Scott Hermanson

  • 90 Points 75 badge 2x thumb
Thanks...hopefully this simplifies:

TABLES:
Customers
Categories
MyFavorites
Magazines
Orders

Each CUSTOMER has many CATEGORIES
Each CUSTOMER has many SUBSCRIPTIONS
Each CATEGORY has many SUBSCRIPTIONS

I would like the following:
1.  Customer subscribes to favorite categories (stored in MyFavorites table)
2.  Customer sees list of magazines based on their associated favorites.
3.  Customer clicks a button next to available magazines to order.
4.  A form would open allowing customer to modify the subscription length before saving (stored in Orders table).
5.  Once customer has ordered a specific magazine, they no longer have the option to order the same one again.

I think I have stumbled my way through items 1-4 but am really stuck on item 5.

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
I would need to understand how you managed to set up #2 in order to suggest how to filter that list to omit magazines already ordered.
When your customer begins step 2, where are they? A report, or a form? On what table?

EDIT: Ninja'd by 3 minutes
(Edited)
Photo of Scott Hermanson

Scott Hermanson

  • 90 Points 75 badge 2x thumb
I think we just need to hire someone to figure this out.  Do you do consulting?
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 29,924 Points 20k badge 2x thumb
It is very simple to do with script. Feel free to contact me off-world using the information in my profile:

https://getsatisfaction.com/people/dandiebolt

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,994 Points 50k badge 2x thumb
Yes, Scott, I do consulting.
Mark Shnier
QuickBaseCoach.com