Hi guys, I am new here and I need some help regarding Grid-View and Calendar:
I have two tables. Table 1 shows Projects which have been booked - every record contains ‘project name’ as a single line text field and ‘project date’ as a date field. Table 2 should show them so I am trying to sync both tables (they stay in one base).
I tried to make an automization:
sync date field of table one with date field in table two. This works fine.
sync project name won’t work because I cannot automize a string with a date field.
My question is: how can I sync project name + project date out of table 1 with table 2?
If there is a thread for this task I would appreciate if somebody can share it with me.
I don’t understand why you would want the data to also be accessible in a different table… Could you explain some more please?
You can’t “sync” between tables in the same base. So unless you’re confusing terms with “linking records” or automating the creation of new records (which can only be done in the same base), syncing won’t work.
We have an event planning company and all of our bookings are being fetched within a list - before airtable we summarized all bookings in an excel sheet and had to use outlook as a calendar system because we not only need a list of our bookings but also a booking calendar. That is why we need a second ‘view’ or table to show three columns of the grid view as a calendar entry.
company name: John Doe LLC
pax: 50 att.
date: 20th August, 2021
event name: dinner event
I need those records to be shown as a calendar entry. I got the automation work with the date - but until now all entries show as ‘unnamed record’ although I automate also the first column of the grid (event name).