Allow user to add record only under certain conditions

I am still evaluating noloco to see if it will work for our needs. I am trying to create an app that tracks prepaid maintenance contracts for our customers. I have a table that has the contract info including expiration date and maintenances left, if any. The service department will add a record to the service table for the service but I don’t want them to be able to add the record if the current date is greater than the expiration date or the if the maintenances left are zero. Could anyone give me direction on this?

I’m not sure that’s possible on a new record button, I did look at this myself but the only conditions that were possible for me were based on logged in user.

You could do it on a record button though I think, choose to create a button that triggers a new record, then set conditions for the date values.

Thanks Gary. Your idea of adding a button and then only showing it under certain conditions appears to have done the trick. Thanks for taking time to respond.

1 Like

You’re welcome, I’m not an expert by any means so maybe an action button is possible, I just haven’t found a way to do that yet.