Update entities uploaded from excel

Update entities uploaded from excel

  

Hi,


I was trying to import a new excel spreadsheet with the same number of columns as the old excel spreadsheet I was working with. The old data does not seem to be overwritten. Any idea how do I delete the old data.


Thank you!

Hi Punya,


You can delete old data by using advanced query in OS.


Thanks,

Rajat Agrawal

Hi Rajat, 

Thank you so much!

Could you please explain in detail. I am just beginning to develop a mobile app. If possible, Can you share a OML file which deletes the old data?

Best Regards

Punya,


See below screenshot, it will help you - 


Thanks,

Rajat Agrawal

Hi Punya,

Did your problem solved or not?

I am also attaching OML for you.


Thanks,

Rajat Agrawal

Hi Rajat,


Thanks. I understood the OML file you sent which you did for a Web App. But, there is no option to add a Screen Action as I am building a Mobile app. However, There is an option to add client action. Would that work?


Best Regards,


Hi Punya,

I send you for web app.

It's mobile app then you can create server logic and call in client action.

We can use advance sql in server logic, so write code in server logic "Delete" as I created and drop him in client action. It will work


Thanks,

Rajat Agrawal

Solution

Hello Punya

I am attaching OML file for mobile, it will help you.


Thanks,

Rajat Agrawal

Solution

Hi Rajat, 


I am in the half way I guess. I created a Delete Server Action. The Next step is kind of Confusing.

Do I have to add this Server action to the Entity under UI flow? 


Thanks,

Best regards


No,

Did you check my OML?


Thanks,

Rajat Agrawal

Rajat,


I Figured out. Thank you so much. The Button we created is supposed to be clicked every time we update the data?


Thanks!