Has anyone else noticed weird bugs with forms
My authoring version is 3.24014.14
1. Some properties of the table can't be accessed. Example, if i have a label in the form with teh formula ThisItem.Amount, it shows up as blank within the form. But if I try to populate the label from a gallery.Selected , it works
2. ComboBox.Selected is not working well. Adding all fields to DisplayFields Property makes it work better, but still erratically. For example if i have a label that says Combobox.Selected.Column1, it is populated if Column1 is included in DisplayFields of ComboBox, but after saving the form,the label becomes blank again , and it is populated again once screen refreshed.
Hello, unfortunately the solution I found at the moment is not to use it!
I also had several problems:
1 - When submitting an item without filling in the field, it would simply enter a random value instead of submitting without a value.
Among other bizarre things
It's not working in the published app url (even after refreshing) . Also some Form Fields take so long to populate that the form if saved before that, gets saved with wrong data, like blank amounts. This feels too unreliable to use at this point, is there any solution ?
It seems to be working now without having changed a single thing, only calculated field columns are showing up as blank now. I don't understand why / how the errors are appearing and disappearing
It's behaving quite erratically again with both simple properties and ComboBox.Selected.Properties appearing blank on both selecting records from gallery and after saving, I'm so puzzled the errors are so erratic
1. The Items Property of the ComboBox is Choices([@Payments].jg__Payee), also tried : Payee.
Choices([@Payments].jg__Payee is what was automatically added to the Items Property of the ComboBox when adding the Payee Field into the form. A label with Text PayeeCombo.Selected.RegistrationNumber works at first when it is a new payment , or when payment is selected from gallery, but stops working and shows blank once record is saved.
2. The DataSource of the Form is Payments Table. The Item Source is varSelectedPayment. This variable is populated by selecting a Payment from Payment Gallery
3. The Payments Table also has some Simple Decimal Columns ,like, TDS Rate, TDS Amount. If I have a label within the form which has the Text Property as ThisItem.TDS Rate or ThisItem.TDSAmount, it works for some columns but shows up as blank for others, although there is definitely data there, as can be cross checked by trying to populate the values directly from Payments Gallery. This issue only occurs after record is saved. It is not an issue when record is selected from gallery.
So,
Working as expected:
ThisItem.TDSRate ,
varSelectedPayment.TDSRate,
PaymentsGallery.Selected.TDSRate ,
PaymentsGallery.Selected.TDSAmount
Showing Up Blank although there is data there:
ThisItem.TDSAmount,
varSelectedPayment.TDSAmount,
I found out after further testing that all of these problems are only occurring after saving a record. When the record is new, or populated by selecting a record from gallery there are no problems. Both the simple properties like Decimal Columns and the LookUp Columns Properties can be accessed correctly when form is new or selected from gallery, they only show up blank when record is saved
My form save expression is as follows
Set(isPaymentUnderProcess,true);
SubmitForm(PaymentForm);
If(IsEmpty(Errors(Payments)),
Set(LastCreatedPayment,PaymentForm.LastSubmit); Set(varSelectedPayment,LastCreatedPayment);
ResetForm(PaymentForm);Set(EditPayment,false);Set(NewPayment,false);
Set(isPaymentSaveRequested,true);
Reset(ResetPaymentAcEntry_Component_1);
SetFocus(AddPaymentIcon);
);
Hi @Rutu01,
More details are necessary.
How you set the Items property of the ComboBox, is it the same data source with the one you populate the Form with?
How you set the Item property of the form?
WarrenBelz
146,605
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional