Solved

What's wrong with this formula???

Posted on 1998-11-17
1
174 Views
Last Modified: 2013-12-18
I have a form that has 2 fields: ReviewerList and From. The ReviewerList field is of type Text (computed). Its value depends on whether the document is a new document or
an edited document.

If it's a new document, its value will be "Joe Average". If it's an edited document, its value will be whatever's in the From field.

The formula for the ReviewerList field below is wrong. And I'm not sure how to fix it.

@If(@IsNewDoc; "Joe Average"; ReviewerList; From; ReviewerList)
0
Comment
Question by:hobster
1 Comment
 
LVL 1

Accepted Solution

by:
wrichard earned 20 total points
ID: 1117648
@If(@IsNewDoc; "Joe Average"; From )

There is a possibility that From may be a reserved word and cause problems.  You may want to rename your field.

Another possibility would be
@If(From = ""; "Joe Average"; From)

This says that if the From field contains no values then the ReviewerList field is assigned "Joe Average", but as soon as the from field contains values then they populate the ReviewerList field.

Hope this helps
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now