Find event in the same date
Hi, I have this formula that allows me to see if there is already an event for the same date when I create a new lead and enter the date of the new event. I would also like to have a nearby field that automatically writes me what the event is (with the name and date, for example). Is there any possibility? Thanks!
let myField := ‘Event Date’;
if cnt(select Jobs where Date = myField) then
styled("There is already an Event for the same date!", "Red")
end
4 replies
-
said:
Is there any possibility?Most things are possible in Ninox.
One that is not possible is for a formula field to modify other fields. Only buttons or triggers can modify other fields. So you could put the following in the Trigger after update for you 'Event Date' field.
let t := this; let jobCheck := (select Jobs where Date = t.myField); if count(jobCheck) then let jobRec := first(jobCheck) otherField := jobRec.name + " - " + jobRec.date end
Another option is to create a view element and put the first two lines in the formula section. Then the view will show you any job records that match.
Content aside
- Status Answered
- 4 mths agoLast active
- 4Replies
- 31Views
-
2
Following