You’re offline. This is a read only version of the page.
390
Good evening,
I have 7 Edit Forms and I want to submit all changes but it doesn't work
Good afternoon @v-siky-msft, I'm trying what you said but apart from filter I want to sort by 'Fecha'. Can you help me?
I think I cannot make a gallery because each edit has a different value from filter, for example the first edit form Item property:
"LookUp(TAREA; SEMANA = Lista_semanas.Selected.NOMBRE && SERVICIO = Gallery_Servicios.Selected.Name && FECHA = Lista_semanas.Selected.LUNES && 'TEAM MEMBER' = Lista_teamMembers.Selected.'APELLIDO PATERNO')"
The second edit form: LookUp(TAREA; SEMANA = Lista_semanas.Selected.NOMBRE && SERVICIO = Gallery_Servicios.Selected.Name && FECHA = Lista_semanas.Selected.MARTES && 'TEAM MEMBER' = Lista_teamMembers.Selected.'APELLIDO PATERNO')
and so on.
I created a Week List wich has Columns named with the names of the days and their value:
Then I created Date List, where every of them has a week assigned:
In that case I can create a planned task selecting the month, week and date. Each 'week' and 'date' has a filter because it allows me not to select another day of a month selected, for example:
So then, I want to show 7 edit forms to specifically show what task is created on Monday, Tuesday, etc... and to quickly edit the planned hours:
I have made a test based on your codes, and it can work properly.
Could you please check if the Update property is correct? could you share it?
As an alternative workaround, I suggest you create a gallery to view and edit the 7 values, instead of 7 editform
1. create a horizontal gallery, add a Textinput inside the gallery
2. set Gallery Item property:
Share
Report
All responses (
Answers (
Filter(TAREA; SEMANA = Lista_semanas.Selected.NOMBRE && SERVICIO = Gallery_Servicios.Selected.Name)
3. set Textinput Default property: ThisItem.'HORAS PLANEADAS' , set DisplayMode property: VarMode
4. add a Edit button, set OnSelect: Set(VarMode,DisplayMode.Edit)
5. add a save button, set OnSelect:
ForAll(RenameColumns(Gallery1.AllItems,"ID","CID"),Patch(TAREA,LookUp(TAREA,ID=CID),{'HORAS PLANEADAS':Value(TextInput1.Text)}));Set(VarMode,DisplayMode.View)
Sik
Regardless of the mechanics needed to refresh the data / what is shown on the forms, I recommend that you take advantage of both the Concurrent function, and the Unsaved property of the Forms. For example:
// If needed, to maybe show a 'saving' prompt to allow the forms to submit asyncronously
UpdateContext({locSaved: false});
Concurrent(
If(
frmFirst.Unsaved,
SubmitForm(frmFirst)
),
If(
frmSecond.Unsaved,
SubmitForm(frmSecond)
),
If(
frmThird.Unsaved,
SubmitForm(frmThird)
)
);
// Add your logic for refreshing, needed
Refresh(Contacts);
// If needed, to hide a 'saving' prompt
UpdateContext({locSaved: true});
This will allow you to only submit changes, instead of submitting all Forms every time. The local variable is optional, to maybe show/hide a saving prompt or to show/hide controls while things process.
Hi @JoseC12 ,
So all of the forms are on the one data source - I was assuming they were on different ones. Firstly, if you refresh between each submit form, it may do the job - if are you trying to write new records on each one, why not simply submit after each one is filled out?
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
I put 'Refresh(TAREA)' between all the 'SubmitForms' and 'ViewForm' but nothing happens:
SubmitForm(Form_HorasLunes);;SubmitForm(Form_HorasMartes);;SubmitForm(Form_HorasMiercoles);;SubmitForm(Form_HorasJueves);;SubmitForm(Form_HorasViernes);;SubmitForm(Form_HorasSabado);;SubmitForm(Form_HorasDomingo);;Refresh(TAREA);;ViewForm(Form_HorasLunes);;ViewForm(Form_HorasMartes);;ViewForm(Form_HorasMiercoles);;ViewForm(Form_HorasJueves);;ViewForm(Form_HorasViernes);;ViewForm(Form_HorasSabado);;ViewForm(Form_HorasDomingo)
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
