Use the "Form Formula" option under View objects in the ojects pane. Simply put "frm2" into this placeholder and this tells the view what form to use when opening documents. then just name the fields on the form the same as the ones in the document.
Yeah I have tried @Trim but it doesnt appear to make a difference? I did manage to solve it though by using
a := @Text(Item1Qty) + " " + "x" + " " + @Text(QuoteItem1);
@ReplaceSubString(a;@NewLine;"")
I still have no idea where the carriage return came...
I have multiple RTF fields on a form which I combine in a single hidden computed plain text field for displaying in a view (as RTF fields cant be displayed in a view). The plain text field computed value code is something like this:
a := @Text(Item1Qty) + " " + "x" + "...
I have an application which I need to have a an action button that will set a reminder in the current users calendar, 2 weeks from the current date.
I'm trying to do this using @functions but I cant seem to set the fields on the reminder form - except for the "AppointmentType" which...
..thanks guys.
Yeah I wanted an action button to open the pdf for printing. I ended up placing the file on a mapped network share and used the @Command([Execute]) to open it - works fine after I worked out the double slash thing!
Now I'm thinking I might place the path to the file on a profile...
Is it possible to launch a database file resource from a form - if so how?
I have a .pdf document in my database as a file resource. I want to have a button on a form that will open the .pdf in acrobat reader.
I am thinking this might be possible with...
OK, this is what I have which I thought should work but it doesnt appear to, the field name is ApproveDate:
TodayDate := @Now;
@if(!@isdocbeingsaved;ApproveDate;
@if(ApproveDate="";TodayDate;ApproveDate:TodayDate)
)
;
I get a single date in the field but cant seem to get the...
I'm a Notes design newbie - I'm developing a quoting system for our company and the quote document passes through various "status" as it is processed. As it passes into each status the status date is recorded in a Date/Time field for each status.
Occasionally there may be a need for...
Thanks for that approach. I hadnt considered doing it that way, but will remember it for the next m2m import problem I come across!
I write in cfm and after a bit of brain racking, ended up writing a small import application I can reuse for importing this data. I figured the effort was worth it...
I have a curly problem!
I have an Access database containing customer marketing information, which I've normalised and contains the following tables:
- CustDetail (customers name, email, address etc. PK=Autonumber)
- Industry (customer industries PK=Autonumber)
- CustIndustry (contains 2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.