- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 05, 2021 04:42 PM
Column A: Active (Checkbox)
Column B: Expiry Date (Date Field)
Column C: Date Created (Date Field)
Column 😧 Package (Single Select)
Contains two packages 2 Week Subscription, 1 Month Subscription
I would like for:
- If the customer has a 2 week subscription enabled then the Expiry Date becomes Date Created + 14 Days
- If the customer has 1 month subscription enabled then the expiry date becomes date created + 31 Days
- If the customer’s subscription is Expired (After the expiry date) the Active checkbox must be deselected.
- If the customer subscription is not expired (Before and on the expiry date) the active checkbox must be deselected.
Can Airtable do this?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06, 2021 01:39 AM
Hi @New_Airtableuser76 and welcome to the community!
U can use automations to do this. U get 100 runs per month in the free version.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06, 2021 09:19 AM
Thanks, how would I also prefill multiple fields in a form? I’m trying to prefill Company name & Job Title.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06, 2021 09:28 AM
You can read up on prefilling form via this link.
Be careful; those who submit a form can always alter the prefilled data. Be sure to mention that they shouldn’t do this :winking_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06, 2021 09:38 AM
Haha true, I tried doing it the way the article said but it didn’t work for my form located here: Job Application Form I was trying to fill Company Name & Job Title
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 06, 2021 10:04 AM
Do you need these to be editable fields or can they be replaced with formulas?
If you make {Active}
a formula field it would be:
IF(TODAY() > {Expiry Date}, "✅")
If {Expiry Date}
is a formula it would be:
IF(
AND({Date Created}, {Package}),
DATEADD({Date Created}, SWITCH(
{Package},
"2 Week Subscription", 14,
"1 Month Subscription", 31
), "days")
)