Can we make a virtual column non readonly? I ...

(Shivaprakash TS) #1

Can we make a virtual column non readonly? I am creating a app for my personal expenses, where all the expenses and income are updated along with their categories and sub categories. In the reports I want to select year and month for checking the expenses of that particular month of a year along with categories and subcategories. I completed the app, but some of the reports are not dynamic as the year or month which I select has to update in the google sheet then after syncing it will reflect in the app. Can some one help me for resolving this issue.

(Tony Fader) #2

@Shivaprakash_TS Any column with an app formula is read only.

You might want to initialize your column with a formula – that will make the column not read only, but still use a formula.

I don’t completely understand what you’re trying to do. It sounds similar to this example: appsheet.com - Custom reports - Reports that users can customize Custom reports - Reports that users can customize appsheet.com