By using this website, you agree to our Terms of Use (click here)
Can formulae be added to a column caption to make the heading dynamic; depending on parameter input?
You can probably do something by using OData and excel. Can I ask why you are trying to do this? I am interested to know the use case.
@ryanxbyte - I have a column that presents the quantity of an item on sales orders x days into the future. I'd like to replace the x with the actual number of days. The date range is defined by parameters.
@timrodman Have you ever messed with changing column names in excel when data is coming from oData? For someone who knows it well, it should be fairly easy to set parameters and have them change a column name. I have not really gotten into oData much so I can't say for sure.
You could also try pulling the query into a report and changing the column header there. That may actually be easier than excel.
See this relevant idea. https://feedback.acumatica.com/ideas/ACU-I-1667
Please vote if it interest you 🙂
I just voted for that feedback idea for getting dynamic column names in Generic Inquiries. Sounds like a cool idea.
As for Excel and OData, you should be able to do this. You'd put the logic in the Power Query portion of Excel which is part of native Excel in the latest Office 365 version.
Online Members
