I wanted the WITHDRAW button to show only if the Start Date (DATE CONFIRMED) is at least 15 days ago.
I couldn’t use the date functions mentioned in my original post to achieve that condition, so I had to use text input fields to calculate the number of days the investment has been running, the days between that are Saturdays or Sundays (I have a table where I have recorded all weekend dates since September) then I can use the number of week days only for my calculations.
I’m trying to make sure an investor who has withdrawn can’t withdraw again till another 15 days have passed (as per the brief I got). It would be so much easier if I could just tell the Adalo system to “do this” if “date” is greater than 15 days ago, or some such clause.
I also notice that the visibility rules are sort of limiting when dealing with text input fields. If I get a number calculated from values in the database displayed in a text field, I want to create a condition based on that number being greater or less than something, but the only options I get are ‘equal to’, ‘not equal to’, or ‘contains’.
These are some of the issues I’m facing trying to deliver an app with Adalo. Hope my explanations are clear enough.