Lookup fields shows html characters in calendar title (v2024)

PHPMaker General Discussion (PHPMaker)
1

Hi all. I have a calendar report. In the title, I have a lookup table that links a person id, and it shows their “surname, name”.
In the calendar, it shows: <span class=ew-option>Surname, Name<span>

I’ve tried changing the “View tags” without success.

Thanks¡¡

2

Don't use lookup field for calendar. If you have to, create a view first, then use the view as the source table of the calendar.

1 Like
3

Thanks. It’s working to show, but I have a problem when I have to add or edit.

For example, my table is called “calendar”, then I create a “calendar_view”. It shows well the names (with no html tags). But If I want to edit a event, when I submit the form I get:
”An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.calendar_view2' doesn't exist”

I don’t know why the number 2 is added. The strange thing is that if I access to the calendar_view list view, the url is: “http://…./CalendarView2List

The edit, copy events… doesn’t fire, and there’s no message in console or network

4

You may set the Update Table of the view as the actual table.

In v2025+, there is Update Table setting. In v2024, there was not yet, you need to set it by server event, you may search "UpdateTable" in this forum.