Hi,
Trying to make a long story short. I want to build a software that I can use to conduct an audit of different softwares, updating things like, licences, cost, users, departments etc. I may not find all of this info in one go so want to be able to add the info in when needed, i.e. and Edit form.
However, I don't want to overwrite any data, as I will need a historical record. Is there a way I can make it an Edit form unless its not blank but then pull the info from the last entry into the new form submission i.e. if the just the cost changes but I need to keep old and new cost, it pulls everything else across without overwriting the old?
Set the Default of your controls in the new form to the fields you have selected in the Gallery for the existing item.
Thank you, how would be best to prepopulate?
Hi @Caggiewaggie ,
If you are using SharePoint, then it does have a Version history, however that may not be what you want. Your best option would be to write a new record each time, but you could pre-populate some of the fields from the old record selected.
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.
MVP (Business Applications) Visit my blog Practical Power Apps
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional