I don't know the use case but you could make a sui...
# general
s
I don't know the use case but you could make a suitelet and store the link to the suitelet on the record, and just have them click that link to export the file after the record saves/create (make the suitelet respond with the file)... Having the page respond with a file download automatically on creation seems like odd behavior to me
s
its probably one to one, every time they create something they want it in excel, I will ask if they want to do it at the end of the day,s so they can get everything they did during that day. but currently they don't want to do anything extra other than Entering Data in NetSuite when they save that data they want excel file downloaded, and they will link that excel to the QMS that we are using.
s
You could try just putting the logic in a UserEvent on create and use
N/https
->
serverResponse.writeFile()
,not sure how the navigation would work in there
s
it's not just on create I think its create or update, and does it have to scripted? there is no SuiteFlow way of doing it?
s
There is no magic way to create an excel file with a workflow that I know of.
s
hmm okay is really complicated script to write? i mean if i tell a partner to write how many hours am i looking at? 10? 40? or more
s
Doesn't seem very complicated to me, just reading some data from the page and making a simple one line csv
s
okay, and do you think, we should create one to one file? or look for all the records created that day and just create one file for the entire day.
s
I think something like a scheduled saved search with all the records that changed/created for the day makes way more sense.
s
I thought so, because if there are 10 customers, 4 vendors and 4 items created i am sure they don't want 18 files, I have asked for more clarification, but thanks for pointing in the right direction, at least its doable.
s
Yeah i would tend to agree, 18 files seems way more annoying than a summarized one for the day
especially if more then one change occurs to the same entity within the day
s
Agreed, lets see what they say in the response, I need more clarification on how they want the excel? because he said Email won't work, so i guess as soon as they save it they want to download that file and once that file is downloaded there will be a logic to read that file to populate the QMS
just got the response, they want to store it on designated network location, shared cloud or network drive, and they want to create it each time, Item or entity is created, so 18 files in our previous example