Formula conditioned

AppSheet AppSheet Q&A
,
1

Hello, I need your support.

I need to make a formula conditioned to two values: one is to the current date, if the day is greater than 15 and the second condition if the customer’s payment is zero (this information is in a referenced table).

I have not been able to bring the payment information found in the referenced table (payment).

The result will be reflected in a field of the primary table, which will indicate if the payment is zero and the day is greater than 15, the status of “debtor” will be automatically set and if the payment is made regardless of the day the status of “active”.

the tables are as follows:

1.- Customer registration
2.-Payment registration

Table 2 is referenced to table 1 by name.

I hope I have explained myself as well as possible, in advance thank you very much for your help.

Cheers!

2

lefarole:

I have not been able to bring the payment information found in the referenced table (payment).

lefarole:

The result will be reflected in a field of the primary table, which will indicate if the payment is zero and the day is greater than 15, the status of “debtor” will be automatically set and if the payment is made regardless of the day the status of “active”.

And you haven’t described an outcome if payment is 0 and day is LESS than 15.

1 Like
3

Thank you very much for your support … in reference to what you say about the 2nd result, I plan to put it so that the formula is complete.

I reiterate my thanks.

1 Like