Share
Report
4,623I have New_Form_1.
New_Form_1 has Gallery_1.
The user can click 'Add Date' to add as many 'Performance Date' and 'On Sale / Bill' items as necessary.
When the user clicks the submit button, I would like all of the Gallery_1 data to populate the same same
line as all the other data, in one cell in the two columns.
Example - If the user creates three performances that data should appear as such in the SharePoint list,
In two columns, on one line with the item submitted. I'm guessing some kind of ForAll
with Last submitted, or something like that.
Peformance_Date OnSale_or_Build_and_Hold
2/4/2025 Build and Hold
2/6/2025 Build and Hold
2/7/2025 On Sale
I am not using SubmitForm(). I am handwriting the submit formula. I've got it all written, there are no
errors. I just need to add the gallery data.
Here is some of that submit formula -
New_Form_1 has Gallery_1.
The user can click 'Add Date' to add as many 'Performance Date' and 'On Sale / Bill' items as necessary.
When the user clicks the submit button, I would like all of the Gallery_1 data to populate the same same
line as all the other data, in one cell in the two columns.
Example - If the user creates three performances that data should appear as such in the SharePoint list,
In two columns, on one line with the item submitted. I'm guessing some kind of ForAll
with Last submitted, or something like that.
Peformance_Date OnSale_or_Build_and_Hold
2/4/2025 Build and Hold
2/6/2025 Build and Hold
2/7/2025 On Sale
I am not using SubmitForm(). I am handwriting the submit formula. I've got it all written, there are no
errors. I just need to add the gallery data.
Here is some of that submit formula -
Patch(Event_Data_List,
Defaults(Event_Data_List),
{
Title: CNE_Attraction_Name_ComboBox.Selected.Value,
Venue_Name: Venue_Name_ComboBox.Selected.Title,
Complex_Name: CNE_Complex_Name_ComboBox.Selected.Title,
Show_Name: Show_Name_ComboBox.Selected.Show_Names,
City: City_TextInput.Text,
State_or_Province: State_or_Provice_TextInput.Text,
Country: Country_TextInput.Text,
Class: Attraction_Class_TextInput.Text,
Number_of_Performances: Value(Number_of_Performances_Lbl.Text)
}
);
Categories:
All responses (
Answers (
