Author Topic: Adding a default value to the prompt like XYZ+ parameter value  (Read 166 times)

Offline rajurokz

  • Full Member
  • ***
  • Join Date: Mar 2016
  • Posts: 19
  • Forum Citizenship: +0/-0
Hello All,

I have a requirement, where I need to add 1100 in front of the loan number.

My input would be 50000000 but the database has 110050000000 i.e. I need to add 1100 to the prompt value in every run. Please help mw achieve this.

thanks,
Rajurokz

Offline BigChris

  • Statesman
  • ******
  • Join Date: Apr 2013
  • Posts: 1,116
  • Forum Citizenship: +84/-0
Re: Adding a default value to the prompt like XYZ+ parameter value
« Reply #1 on: 13 Apr 2018 01:57:59 am »
Create a query to feed your prompt with two fields

[Original Field]
Either (110000000000 + [Original Field] ) or ('1100' || [Original Field] ) depending on whether [Original Field] is a string or a number

Then in your prompt you can Display the second field and Use the first

 


       
Twittear