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.
1 of 1 people found this helpful
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!!!
1 of 1 people found this helpful
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.