I'm trying to set up a LOG field default expression. I'm logging my MARS station activity and we don't identify specific frequency assignments over the air, instead we refer to channels, for example NECOS will tell all stations to change to D002. I want to set up a default list so that when I enter a CHANNEL into my log, it will also populate my FREQ with the actual frequency value. I have created a table called CHANNEL, with entries such as D001, D002, D003 etc. Using a LOG DEFAULT setup, I want my FREQ to be populated with the frequency associated with the corresponding CHANNEL list item. For example I would enter D002 into the CHANNEL field when creating that log entry, and I would like the FREQ value updated based on that CHANNEL entry when the log entry is created.

Basically I am trying to perform the following:

FREQ = 4.0 IF CHANNEL = "D001"
FREQ = 4.1 IF CHANNEL = "D002"
FREQ = 4.2 IF CHANNEL = "D003"

Using the DEAFULT FIELD builder, I am entering the following:

Field.........Expression
FREQ........IIF(LOG.CHANNEL=="D001",4.1)

When I click OK I get error: This is not a valid expression. Missing comma(,). Run expression builder?
Running the expression builder doesn't help me at all, not sure what it is I need to do to correct this.
My userfield for CHANNEL is defined as text, so I'm enclosing the list value in quotes "D001". The FREQ is the standard LOG FREQ value, F.

I've also tried:
FREQ IIF(LOG.CHANNEL=="D001",4.1,)
FREQ IIF(LOG.CHANNEL=="D001",4.1,0)
FREQ IIF((LOG.CHANNEL=="D001"),4.1,0)
FREQ IIF((LOG.CHANNEL)=="D001",4.1,0)

I can't figure out what comma is missing. Any help in figuring out the correct expression will be very much appreciated.

Thanks Dennis,

The GETUSERFIELD is the operation I was missing. Don't see that anywhere in the HELP. Also, I have too many rigs at several different locations to list them all and tether them to the log. Logging is done on paper and entered when back at the home station.

The way I use this for MARS is at the start of a net, I know what channel we are on, so I enter the channel first before starting to enter stations, beginning with the NECOS. If we switch channels at any time I just enter the new channel and start continuing the log with any station that checks in on that channel. I'm actually entering a list over a hundred channels for MARS, and I have not memorized the CHANNEL/FREQ combination for each. Having the log pull up the FREQ when I have identified the CHANNEL keeps me from having to consult a list.

Thanks for your help.

73
Paul W2EC

Hi Dennis,

I need to make a list called CHANNEL containing "D001" thru "D100".

Using your ICASE(GETUSERFIELD("CHANNEL:")=="D001", 4.0, GETUSERFIELD("CHANNEL:")=="D002", 4.1, GETUSERFIELD("CHANNEL:")=="D003", 4.3, 0) worked fine for me.

However, I actually have 100 entries in my CHANNEL list so need to figure out a way to loop thru the entire CHANNEL list searching for a match so I can populate the FREQ field with the frequency identified by that CHANNEL value. Since the line entry is limited to 254 characters, there is no way I can see to create an expression to access all 100 entries. Is there such a capability to perform an if-then-else type loop?

I also read about a dropdown list, I was thinking if I could have such a list assigned for my CHANNEL list, I could just use the dropdown, select the CHANNEL from it and populate the FREQ with the frequency associated with that CHANNEL. The problem is I haven't been able to actually create my CHANNEL userfield as a dropdown list. Is there some option I am supposed to be selecting to make this happen?

73,
Paul W2EC

Ok, as per this post, there is not any to do what you suggest.
http://www.hosenose.com/...-list-use.aspx#post7254

However, here is an idea. Could the freq be derived from the description using a formula? Are the channels evenly spaced?

Tnx & 73,
Dennis WN4AZY

Thanks Dennis, I will update and try this when I get home this evening. All the channels are in radio memories, I am using two different radios, an Icom F8101E and a Kenwood TK-90, both dedicated to MARS operation.

73,
Paul W2EC

Still waiting for my LOGic update renewal so can't move to 9.1.24. All I've been able to install was 9.1.22, the last version that was covered by my subscription.

However the 9.1.22 update is failing. After install and launch of the 9.1.22 updated version I get the following error message:

Error 1429 "OLE IDispatch exception code 0 from EntityFramework: An error occurred while executing the command definition. See the inner exception for details..." has occurred in program PREFIXLOOKUPSETUP, line 41. Attempt to continue? Yes / No

I have tried the Yes selection and things seem to work after that. But this error message appears every time I restart LOGic 9.1.22 so I'm afraid to log anything in case something is messing up that I won't be aware of until some time in the future.

73,
Paul W2EC

I uploaded 9.1.25 last night. You can use it to get the freq from the Radio Memories file. Assuming the category is MARS and the channel is in the COMMENT field (you can't put D001 in the channel field of the radio memories since they are numeric only), this would be the expression:

LOGICDATA.RADIOMEMBYCOMMENT("MARS", GETUSERFIELD("CHANNEL:")).FREQ)

73,

DH