Create New Form by Product and Create New Form by Product Group

I need help trying to figure out how to adjust the buttons connected to my forms. Attached is an example dataset. Please help!

The purpose of this form is to provide users a way to save information (Comments, Price, Units, Date) at the product level (Gala Apple, Fuji Apple, Grapes). I would like to create two buttons, "New Record - Product" and "New Record - Group".

"New Record - Product" - when selected, will create NewForm(Form1) with a record ID that is the highest Recid + 1 for the product. For example, since the highest Recid for Gala Apple is 5, the new form will prepopulate Recid with 6. How do I accomplish this?

"New Record - Group" - when selected, will create NewForm(Form1) with a record ID that is the highest Recid + 1 for the product group. For example, since the highest Recid for Gala Apple is 5 and Fuji Apple is 2, the new form will prepopulate Recid with 6 (using Gala Apple, since it is the highest). How do I accomplish this?

I have set global variables SelectedProduct (specified product) and SelectedRecord (specified record number), as well as a collection ProductRecords (all record numbers for specific product). However, I am not able to make any formula that seems to work. Would there be a difference if I used a Set or Collect/ClearCollect formula?

Any help will be greatly appreciated!

Categories:

General Questions

Using Apps Using Formulas