Provide a Sequent number for every portal row

[voltrate]

Hi,

anyone knows how to go about providing a sequent number for every portal row? I am rather new to FM7 and hope you can provide me the solution step by step. Thanks a lot in advance.

[LaRetta]

Hi voltrate,

Drop into Layout mode. Click into your portal. Type @@

@@ is the record number symbol. If you want a simple numbering of your portal items, this will do it. If you want something more, let us know and we'll help you with it.

LaRetta

[voltrate]

Hi LaRetta,

Thanks for your prompt answer. I really appreciate it. I have another question which I need your expertise. I have a transactions table to receive multi payments for a Invoice table. In this transaction table, I have a field called "payment date" which is defaulted to the current system date using Get (currentdate)function. Question here...is there a way for user to overwrite the default date and input another date of their own?Currently its not allowing user to do so. Thanks.

Voltrate

newbie

[LaRetta]

is there a way for user to overwrite the default date and input another date of their own?

There sure is, Voltrate. Your PaymentDate field should be a standard date field. Set it to Auto-Enter calculation (through Options) with: Get(CurrentDate). Be sure the checkbox right under 'via Calculation' in the Auto-Enter tab is CLICKED.

It will insert the current date when a new Payment is added, but allow a User to type in a different date whenever they wish. If Users can't type into the field, I suspect two things: 1) It's currently a calculation instead of a standard field or 2) It is not allowing entry into field in Browse (check Field Behavior).

LaRetta

[voltrate]

Dear LaRetta,

I got it! Cheers. Hope you don't mind helping me on another problem which I have been cracking my head on. My "invoice" table has a field which indicate the number of months which the "balance amount" will be repaid on a monthly basis. I also indicate a field with "payment start date" to show when the monthly transactions will kick start. Question here....can I automate in such a way that, every month when a transaction relating to a invoice occurs, the "due date" field in "transaction" table will indicate latest due month/date.

Here's an eg,

1) Payment start date (from Invoice table) = 05 Jan 2005

2) 1st New transactions(from transaction table), payment due date field = 05 Jan 2005.

3) 2nd New transactions, payment due date = 05 Feb 2005 and so on.

Thanks.

[-Queue-]

Are you assuming only one transaction per month? If so, you could try making Date_PaymentDue an auto-enter calculation of {UNTESTED}

Let ([

Dend = Date( Month(Invoices::Date_PaymentStart) + Invoices::Num_Months; Day(Invoices::Date_PaymentStart); Year(Invoices::Date_PaymentStart) );

D = Date( Month(Invoices::Date_PaymentStart) + Count(Transactions|InvoiceID::serial); Day(Invoices::Date_PaymentStart); Year(Invoices::Date_PaymentStart) )]

Case( D <= Dend; D )

)

where Transactions|InvoiceID is a self-relationship based on InvoiceID.

This may need to be tweaked depending on when InvoiceID is set.

[voltrate]

Cheers. I will digest your suggested solution and see if it works. Thanks.