Hello. I’m making a system to keep track of my registrations, and could use some help. First issue is that when I added a new vehicle, the info doesn’t get added to the registration table. I think I can easily fix that if I make the registration table a view of the vehicle table instead of it being an independent one.
I also have formatting to make the row yellow when the current date is within 30 days of today’s date, but can’t get it to work.
Finally, I made a system to record payments and receive registration cards. Upon clicking Receive, I want the date to move forward 1 year. I’m a bit lost with the warning that tells me that the date is not in the right format.
welcome to community @Kris_Jones
- I like your idea of creating views instead of separate tables - and I believe would work well for your use case. if you still would prefer to keep two separate tables - you could either rely on buttons or on automation to create records in both tables
- regarding making row yellow - do you want to highlight rows that are due in next 30 days? if so, the formula would be
thisRow.Due <= Today() + 30 AND thisRow.Due > Today() (I added AND condition to make sure you dont highlight the rows that are in past)
3.I see that you have already figured out relative date formula - and I dont see any warning about “right format” - could you please put a screenshot?