Hi community !
It seems like I am doing something wrong.
I would like to create a form (or multilple forms) in one screen to enter sales forecast for 12 months. The user will have to chose a department, and a year, and then enter his prevision for each 12 months of the year.
Example : Department Women, Year 2024, I plan on selling 300 000$ in January, 250 000$ in February, etc.
When I submit my form, I should see 12 new rows in ma data table.
Here is my datatable (dataverse) :
I started with a sample of 4 months, so I created a first Form to select (1) a Departement and (2) a Year, and then 4 other forms to enter the sales forecast :
I followed some tutorial on youtube, and here are some of the steps I followed :
- My forms are in FormMode.Edit
- In Items of every forms, I wrote " Defaults(SalesForecast) "
- DataSource is "SalesForecast"
- In Default section of Month_Datacard, I manually entered "Janvier" for the first month, "Février" for the second month, etc.
I then wrote this code on my On Success of submit button :
Patch(SalesForecast;
Defaults(SalesForecast);
FormulaireSaisie.Updates;FormJanvier.Updates;FormFévrier.Updates;FormMars.Updates;FormAvril.Updates)
& NewForm(FormulaireSaisie)
& NewForm(FormJanvier)
& NewForm(FormFévrier)
& NewForm(FormMars)
& NewForm(FormAvril)
& Navigate(SucessScreen)
But I have an error message. In french it says :
Can you please help me 🙂
Oh and also, do you know I do I remove duplicate from my dropdown list in the form ? :
Thank you !!!
