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.
(i edited this to make more sense hopefully浪)I want to create a new date and time, by stripping the time from a date, add a certain number of days, then add a duration field back as a new time to the date such as :1/3/24 11:00 am to 1/3/24 add...
What is the proposed idea/solution?My suggestion is that you make all desktop data views and interfaces phone fields function just like the mobile app so that if you click on it you have the option to choose Call or Text (tel/sms). Workaround is to a...
I'm trying to have the formula with a dateadd calculation be blank of a certain field is blank. However if I put the DateFormat function around the whole If formula it will either result in an error if the input is Blank or if any option could be bl...
This is Conditional Logic that is very simple, one of the conditions is the "has any of" and that is selected from the single select field as "CTC" and then it just fails and shows the result from that field as [object Object}. What is causing this?...
I am confused. I do not have very many records but some tables have about 150-250 fields per record. When I use the interface designer is it the SLOWEST thing to edit, to the point of being useless. Why would this be as I only have like 200 records ...
Yes I went down that road with tel/sms url & buttons etc and they do not work on a PC browser. On Mobile it works natively. I bet 90% of the Airtable users use some sort of CRM contact and such in their applications.
Hey thanks for the input, I was having some issues with my formula triggering when it was in the evening closer to midnight, so I revamped it and tweaked it for 3 hours last night through midnight mst until it finally I think it is good now but I mea...
FYI my work around is to compensate by subtracting 64,800 sec and adding 1 day for the weirdness but it seems so unnecessary : DATEADD(DATETIME_FORMAT(DATESTR(DATEADD(DATESTR({Initial Date}),{Days to Add}+1,'d')),'MM-DD-YYYY'),{Duration}-64800,'s')
Thanks, that must be common to use in coding but I'm more of an excel guy, not even VBA. I don't even format anything, I set up these conditionals linearly and read them like a sentence! I need to learn your ways.
It does work! I am curious about this formula you all made. Does it help that there is not an actual condition such as {weekday planner}="" ? What does it mean when it is simply If({weekday planner}, X) and there is no other option. Does it mean...