Announcements
I have this form, which have Default Mode = New and its Item property = "Lookup(large123,ID=5691)" >> where the idea is that i want to default the form to have the values from the item with Id = 5691.. but currently when i issue SubmitForm(Form1) >> the item with ID = 5691 will get updated instead of creating a new item, although the Default Mode of the item = New and not Edit. any advice?
Thanks
Does your data source have a Primary Key column? If the primary key is ID, then its seeing 5691 and choosing to overwrite it. If you are asking your form to default to an existing ID and entry, then it makes sense to update regardless of your form's type.
Make sure your Primary Key isn't the same as when you are using to pull defaults in the form. If not this, try using a Patch function instead of form submission, but patch the individual fields in the form?
@johnjohn123
Providing the Item will always switch the mode to update .. regardless of the default.
So if you wanna show default values in the form , add a default value to each control and do not set the item property.
@Mira_Ghaly the weird thing, is that if i am in Design mode the item will get updated, but if i publish the app and i click on submit on runtime mode nothing will happen, no update or create will happen
@Ginko the weird thing, is that if i am in Design mode the item will get updated, but if i publish the app and i click on submit on runtime mode nothing will happen, no update or create will happen
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 432
Valantis 362
timl 337 Super User 2026 Season 1
