I'm trying to write a field calculation;
Previous field's date + 30 days
It would really be helpful if you submitted your file; or a simplified version of your file.
1. While in layout mode
2. SELECT the field
3. NOW choose control style
4. While the field is still selected - now select "Values from" and choose the value list you defined.
And where is the "previous field"? In another record? In another field of the same record?
In the previous field on the same record
The requirements are not very clear.
If we assume you mean that you would like the date to be the date from the previous record plus 30 days:
GetNthRecord ( datefield ; Get ( RecordNumber ) - 1 ) + 30
If that is not it, you will need to explain what you are trying to do.
OK so my attempt was not the right answer
Given you know the name of the 'previous' field, you would use:
datefield + 30
I think that is what Im trying to do, but I am absolutely new at this so my language is very limited...
I have a date in a field on the same record. In the next field I would like to calculate the previous filed's date +30
You're a GENIUS! Thank you!!!
Since you are new to this, you will find it more helpful to describe what it is you are trying to achieve rather than preempting the solution. For example, in this case, what is the name of the first field and what does the date represent? And same for the second date field.
I am creating a library database and I have a field that auto-enters today's date into the "loan date" field. I would like the "return date" field to automatically enter a date that is 30 days after the loan date. What is the best way to do this?
In the above case, the best solution is probably not a calculation field -- it is an auto-entered calculation in a date field (and that calculation would be Loan Date + 30 ).
With reference to your comment "my language is very limited", your use of the word "previous" is needlessly confusing your question. Since the two fields are on the same record there is nothing logical that makes one field come before the other, which is what previous means. Your question really means: I would like the date in one field to be set to 30 days after the date in another field. Once that was understood, your question has been well answered by others.
Can I ask you another question?
I don't know if I will pose this correctly but here it is;
I want to create a field with two options. either a radio button or a drop down menu. In either case, I am having trouble getting it to apply. It says Value list Missing. But in the help option, I see nothing about it.
So A: how would I pose this question properly and B: Could you or anyone else aid me in this?
Again, this is better but you need to be less secretive about what you are doing. In this case, you need to let people know what you have done so far so they can see if you are on the right track.
I suspect that you have chosen for the field Control Style to be say a radio button in the Inspector but you have not selected a value list to use.
Select a value list if you already have one, or click the pencil icon to create a new value list.
Your question is fine as stated.
What you are asking for can't be done. While there are many field format options you can only select one of them. The field can either be a drop down menu or a checkbox but it cannot be both.
Ask yourself these questions.
(If you can't come up with an answer then provide the answers to these questions and ask "How do I accomplish this? I tried X, Y, Z but couldn't get it to work." Whenever pertinent tell us what you've tried. You may not be looking at the problem in a way FMP can resolve it. This way we know if we also need to explain WHY we suggest a particular approach.)
What GUI (Graphical User Interface) problem are you trying to solve.
How do you anticipate the End User interacting with this user element?
What is the desired result?
He did say "either a radio button or a drop down menu"
When he said "two options", I think he meant two value list items.
Yes, he did.
He also said, "I want to create a field with two options."
Since those two sentences are mutually exclusive I guess it depends on which words you think he really meant. §^=)
When he said "two options", I think he meant two value list items. That bit was not clear.
Wow, thank you both for your attention.
First, "He" Is a She.
Second what I would like to do is create an option to either show that the record is of a `Client or a Vendor. I was thinking the radio buttons would be nice, but a drop down menu would work as well.
I've tried going into the Insert menu and selecting Field/control and later, drop down menu. The problem is that I can not figure out how to name the value(Value List Missing) (if that is what I am expected to do) nor can I simply create a field with the drop down menu. I could have two fields, one client and one vendor OR I would have one field named Relationship with the drop down menu specifying which they are...
Does that make sense?
For any of these control Styles to work there must be a Value List for it to refer to. Look back at David's earlier reply with the image of the Control Style dialog. Taking that a little further, select the field you want to set up and then click on the pencil icon as shown by David a dialog box called "Manage Value Lists for <your file name>" will open. If you then click the NEW… button at bottom left the following will open—this is where you create your Value List. In my screenshot I show the simplest form—custom values—which should suit your purpose. Once you have created the list and go back to your main layout, you will find that FM has already assigned the new list to your field.
Apologies for the gender confusion
Rather than using the Insert menu for this, I would advocate adding a field to the layout and then using the Inspector to set the options.
As per full description from Keywords.
Ok, So I have tried going to file menu, manage, value lists, creating a new value list name "Relationships", double click to edit value list, use value from field, specify field, in the table, "New Solution" selecting my "Client" field, then selecting also use values from second field, "Vendor". But when I created the fields, the only field 'value?' that is close is Text... but I don't need to add txt, I just need a field named Relationship with two radio buttons, one indicating vendor and the other indicating client. It is only one or the other that can be checked.
Does this make more sense?
And after all of that, I tried to select within the control box the radio button option, but the control box is muted...
Yes, you're absolutely right! I finally figured it out!
Retrieving data ...