[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 233
  • Last Modified:

@error in computed field

Hi,

I have a field in a form that is computed.  The number id placed in this field is the next consecutive no.  This is now not working and @error is being placed where the id no. should go.
Any ideas?
0
Lucret
Asked:
Lucret
  • 5
  • 5
  • 2
1 Solution
 
HemanthaKumarCommented:
What is the formula and field type ?

Probably you are substituting text with number data type, or the dblookups can cause this kind of problem.

So be specific.

~Hemanth
0
 
LucretAuthor Commented:
Type : number computed
Can't find the formula, where do I find that I'm looking in designer

0
 
HemanthaKumarCommented:
check the default value of the field
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
ArunkumarCommented:
Hi Lucret...

Select the Field and select from the menu : View - Programmers Pane.  You will now be able to see two new panes.

The Left pane would read  "Value" , "Options" , "Declarations" , "Intialize" and "Terminate" as its a computed field.

Select the "Value" and you should see the formula in the second pane to the right side of this pane.

Also, I suspect that this has a @DBColumn Formula for next number generation, that might have exceeded the limit and thats why an @Error is raised...

Let us know how we could help you!

-Arun.
0
 
LucretAuthor Commented:
When I select value all thats there is TRFNumber could this be referencing something else
0
 
LucretAuthor Commented:
else where in the form there is an ID field with a value of @Text(@DocumentUniqueID)could this be related
0
 
ArunkumarCommented:
The TRFNumber should be the name of the field itself or referring to another field.  Check if you have another field of that name.  Whats this fields name ?
0
 
HemanthaKumarCommented:
The problem could be in the TRFNumber field formula. Similar to this field check its field value for formula.

0
 
LucretAuthor Commented:
Hi,

the problem was that the document defore the error occurred was corrupted
0
 
HemanthaKumarCommented:
Not my fault ;-)
0
 
LucretAuthor Commented:
SOUND
0
 
HemanthaKumarCommented:
And who is this Sound ?
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 5
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now