u/Rough_Ad6878

Classic form prefill not populating a simple text field

Trying to prefill a classic Airtable form via ?prefill_FieldName=Value. Field name matches exactly, but the value never populates. Tested with a single Text field, signed in as owner, no filters on the field.

This is for a form built in the Forms tab on the website, so it's not an "interface" form as far as I can tell (not sure what that is).

reddit.com
u/Rough_Ad6878 — 9 days ago

Is there a less painful way to do rolling WTD/MTD/YTD totals per-person than my Link+Rollup+scheduled-automation gymnastics?

Building a company ops dashboard - need revenue totals per staff member, each broken into This Week / This Month / This Year windows. These metrics will be displayed in a dashboard. Here's what I've landed on, and I'm hoping someone's found something less cumbersome:

Current approach, per metric:

  1. Hidden Link field on the transactional table (Jobs), pointing to the per-entity table (Staff).
  2. An automation sets or clears that link based on whether the Job record's date falls in the current window (e.g. a YTD link exists only if the record's Completion Date field falls within the current year). This is because Rollup fields can't filter, they only sum whatever's currently linked, so the filtering has to happen before the rollup, at the link itself.
  3. A Rollup on the entity table (Staff) summing the Cost field of the linked records.

Then in the dashboard, I'll create a list element that displays the Name and YTD Cost rollup per record in the Staff table.

This works, but it feels hacky and I can see this causing significant lag when there's 15 hidden link fields and thousands of records.

Am I missing the obvious way to do this?

reddit.com
u/Rough_Ad6878 — 21 days ago

Linked records: why show the whole card when I just need a name to click?

Is there a way to have the linked record picker show only the Primary Field i.e. a simple clickable list instead of the full field card, which also pulls in every backlink column?

For context: even with as few as 10 records in the linked table, the current card view already requires vertical scrolling. Notion's relation picker is the behavior I'm hoping for, with the primary property shown as a compact, clickable list, full record available on click if needed.

Is there a native setting for this, or a known workaround to get a leaner list view?

There's no way my client is going to be happy with how the card looks in the attached image.

u/Rough_Ad6878 — 1 month ago

Workflow and automations can't share logical paths... seriously?!

How is anybody successfully building any automations in this software? Tell me I'm wrong, please...

Simple logic example

IF a == 1 OR a == 2 OR a == 3

print(a)

ELSE

print(b)

END

Implementing it in Monday com's Automations:

IF a == 1

print(a)

ELSE

print(b)

END

IF a == 2

print(a)

ELSE

print(b)

END

IF a == 3

print(a)

ELSE

print(b)

END

reddit.com
u/Rough_Ad6878 — 2 months ago