About Rosemary

Rosemary · 07-30-2021

I aplogise if this has already been answered, but if it has, I have been unable to find it and I have spent quite a while looking through the questions and support docs. I am looking for advice/information sheet about how to control the colour of the...

Rosemary · 07-23-2021

Hi I am working on a little app to record and evaluate diet information. At the end of each day the user enters their consumption info (which is captured with a Diet Diary App) . This is a variables like calcium, protien, vegetables and importantly, ...

Rosemary · 07-20-2021

I see that there are options for Trend Lines on the Histogram Chart but this is not available on the Column Series Chart. Also once the Trend Line is generated it would be handy to be able to fade out the data line. Could these two pieces of function...

Rosemary · 07-09-2021

How do you make a Virtual Column that contains the running total of values in another column? My data key is the DATE field. The data column contains Calories Consumed per Day. I want to make a Running Total of Calories Consumed per Day. E.g.: 1800 c...

Rosemary · 07-09-2021

I have loaded data from my excel worksheet and it mostly looks good but some columns come up with the correct header but no data. I just get blank cells. I can’t find any pattern to it. I have confirmed that my column fields are all formatted correct...

Rosemary · 07-31-2021

Hi Steve thanks for picking up my question. I haven’t come across the ‘ANY’ function in my reading yet or at least if I have I didn’t comprehend that I should use it for this! BTW you probably recognise the question. The other solution you gave me (P...

Rosemary · 07-31-2021

Thanks for your replies, Tsuji and Kirk. I am just using the Out Of The Box Card UX. So from what Tsuji has said, it isn’t possible to conditionally format the colour. Pity. But thanks Rosemary

Rosemary · 07-30-2021

HI There I see no one has replied to my question yet. Perhaps I offered too much detail… To simplify: I want to know how to write an expression in a column in my main table that picks up a value in a different table based on the date of the record in...

Rosemary · 07-26-2021

Hi Steve, thanks for the tip about putting the formula in the Initial Value area. That seems to have done the trick! It took quite a bit of messing about. I had to have data in the excel file for all past dates and then test with future dates only. A...

Rosemary · 07-24-2021

Thanks Steve, Yes sorry I tried to be clear in my previous response. The problem with [PRIOR DAY].[CALORIE TARGET] Is that I need to put that formula in the CALORIE TARGET column and AppSheet regards that as a circular reference. I would be delighted...

My Stats

Rosemary's Bio

Badges Rosemary Earned

Recent Activity

UX View Type: Card

GET VALUE for Table 1 from Table 2 WHERE Table 1 Record's Date FALLS BETWEEN Table 2 Record's START& END DATE

Include trend lines on col series line chart

Running Total

Some columns' data doesn't load from Excel

Re: GET VALUE for Table 1 from Table 2 WHERE Table 1 Record's Date FALLS BETWEEN Table 2 Record's START& END DATE

Re: UX View Type: Card

Re: GET VALUE for Table 1 from Table 2 WHERE Table 1 Record's Date FALLS BETWEEN Table 2 Record's START& END DATE

Re: Copy data From above Row

Re: Copy data From above Row

Rosemary's Ideas (1)