This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
I have a base I use to request rooms. Is there a formula I can write to let me know if there is overlap in a request?
For example:
1/10/2022: I have a request for 4 large conference rooms for Group 1 from 10-12
1/10/2022: I have a request for 3 m...
Hi,
I have a rollup field (called “Lessons Included”) that won’t work in the following formula:
IF(AND(FIND(“Math”, {Lessons Included}), {Submit Date}=BLANK()), “Math Pending”,
IF({Submit Date} = BLANK(), “Math Not Included”,
DATETIME_DIFF(
{Material...
Hi,
I have a conditional rollup where I am doing an Arrayunique of events that occurred in a specific Academic Year.
If the array is empty (meaning, the event was not scheduled in said year), then I want the rollup field to say “Not Scheduled”. Is th...
Hi,
Using the following script from this post, I created a field that combines a URL and text:
let tb = base.getTable(“URL Test”);
let query = await tb.selectRecordsAsync();
for (let record of query.records) {
let url = record.getCellValue(“URL”);
le...
Yes, the items in Column 1 are comma separated, and they are linked records in Column 2. It’s unfortunate that I can’t write a formula, but thanks for the suggestion on a script - I’ll look into that!
This works great! If I have a lookup in another table to the formatted text, the lookup loses the link. Is there a way to retain the rich-text formatting in a lookup or rollup?
The tables that are linked are called “Parent-Child” and “Calendar Events”. As you can see from the second screenshot, the “Parent-Child” field was created. It unfortunately isn’t populating.
