Profile cover photo
Profile photo
Sakis Koukouvis
Interested in Technology, Social Media, Digital Marketing, Science, Politics, Social Justice, Philosophy and Metaphysics
Interested in Technology, Social Media, Digital Marketing, Science, Politics, Social Justice, Philosophy and Metaphysics

Sakis's posts

Hi, to the community

I have a problem with one of my apps

I have a table ERGO with gardens from our customers.

I have another table FIVA with the scheduled maintenance visits from group of our gardeners. Of course I have a date column. In this table I have a reference column "Related FIVAs [ERGO]". It shows the scheduled maintenance visits for the gardens of the ERGO table.

My problem is that I want to find the gardens (of the ERGO table) which are not scheduled in the FIVA table by Month. I don't want to forget a maintenance of any of the gardens.

What could I do?

Hi, members

I have another question about expressions.

I have a table with 2 fields for prices.
[HS]: field with a fixed price for High Season (Months: 1,2,3,4,5,6).
[LS]: field with a fixed price for Low Season (Months: 7,8,9,10,11,12)

I have also a field [MONTH]

I want to create a virtual column.
In this column I want to take the price from [HS] only if the field [MONTH] is 1,2,3,4,5,6 and the price [LS] if the [MONTH] is 7,8,9,10,11,12.

What is the correct Syntax for the App formula? I suppose that is a combination with IF and OR, AND expressions but I am confused.

Is there a friend to help me?

Hi, I want some help from the experts

I have a table SALES
In this table I have a DATE field
I want to find data from this table with a selected range of dates
BETWEEN [...] and [...]

I want to choose every time the dates I want.

Is this possible in AppSheet?



I have a question wth Action in Enumlist field

I want to add data in a Enumlist field with the Action function.

The problem is that every time I use the Action function, the field is updated with the new entry. I want to add a new entry without loosing the data that is already in the Enumlist field.

What could I do?



I have a problem.

In one of my tables I have a field by type "duration".
When I want in UX to see the amount of the duration by GroupAggregate, the choice "duration" doesn't exist. I see the choice "price" because I have another field with this type.

Why I couldn't aggregrate Duration?

Post has attachment

Today, I saw a change in my apps.

When I open a record from my laptop, I don't see the NEW button.

This problem exist in al my apps only when I open them from my desktop or my laptop. I don't have it in my mobile app.

What is the problem?

Thank you



"Actions" is very useful but I want to know if I could use an expression to the field 'To this value" that it would be a variable or a list.

For example: I want to make an evaluation using one of the numbers 1,2,3,4,5. Is it possible to have one only "action" that it could show me the list of these numbers and I would choose one of them for the column value?


Hi to all members

I have one problem and I would like some help.

I have one table CUSTOMERS with a unique ID

I have another table "1st meeting". In this table I record meetings with customers from the first table
If they want a second meeting I have a field (Y/N) in the "1st meeting" table and another field for a future meeting date.

I have a another table "2nd meeting". In this table I have meetings with customers from "1st meeting" table who they asked for a 2nd meeting.

My question is:

I want to have a filter table (I suppose a slice). In this I want to see customers from "1st meeting" (with "Υ" in the field for the future 2nd meeting) that they aren't in the "2nd meeting"
My purpose is that I don't want to "lose" customers who they asked for a 2nd meeting.

Which is the more easy way to find a solution for this?


Please, I want to record voice inside the app.
Is it possible;


I have a column in the form of Datetime.

I want to create a virtual column in the form of Date to show only the date of the Datetime Column.

My questions are:
How I could do this?
How could I group data in the menu of the app grouping data per date?

Have a great weekend
Wait while more posts are being loaded