I’ll do my best to describe this.
Description
I have a base with two tables. Table 1 is an import of course records in a csv file. Table two is linked to a sanitized view of this data. Each course has a unique identifying number. Some of these course...
I am trying to convert TODAY() to the WEEKDAY() and then to the single letter for that day of the week. I need to match that to a data feed that provides the day of the week as a letter. Here is my formula:
SWITCH(WEEKDAY(SET_TIMEZONE(TODAY(),'Americ...
I am getting an export that expresses a start and stop time as text in 24 hour format. I am trying to make this into AM/PM. Thoughts?
Input:
730
1130
1330
1700
Desired Output:
7:30 AM
11:30 AM
1:30 PM
5:00 PM
Hey there.
So, I have a base with a table of inventory of devices that includes their IP address. On that table, I already made a button column that where you click on it and it takes you to that device using the protocol best suited for it (VNC, HTT...
I am attempting to have an automation that every Monday morning will look in a table for specific records and then broadcast that into Slack.
I got the trigger and record searches to work, but when I attempt to place them in the message, all I get ar...
Good clarifying question.
It’s #2. All courses have the field. It is blank if they are not cross listed and have a unique pairing code (that can span as many as for courses).
I stumbled into a solution, but I think I am taking too many steps or it is...
No. Right. I knew lookups always return as arrays. What tripped me up is the lookup formatting was set to integer. I can even do something like {Lookup Field}+50 and it will add 50 to the value.
So, at the very least, it is an inconsistency where som...
Ah ha!
Had to use the ole &'' trick on it cause even though the lookup formatting is making it an integer the formula is still treating it as an array cause it is a lookup field type. That might be a bug…
I forgot to mention (sorry) the time data is coming from a lookup. ARRAYUNIQUE and ARRAYFLATTEN don’t seem to be doing the trick, so it’s returning an #ERROR. The lookup is already formatted as an Integer and it works for doing basic math, so super o...
Interesting.
I always thought NOW() was when you put the command into the formula and that it didn’t update dynamicly. I’ll try it.
EDIT: I’ll probably have to wait for the GMT rollover at 4PM PDT to see if it works. Cause it’s hard to tell since Air...
