(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 ...
just dealing with this ...I made a formula for the interface URL record link and that opens in a new tab but when I make a button referencing that same link it opens in the same tab. However when you create an "Interface Button" it has the toggle to...
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')
