Fred

San Francisco, USA

3524
550
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

Re: SELECT function
If you are in TableA and want to count the number of related records in TableC through TableB, you can do something like: count(TableB.TableC) If you are in TableA and want a formula to count the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: SELECT function
which table will the count formula be in?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: SELECT function
Which direction does the 1 to many go? TableA has a 1:N to TableB or TableA has a N:1 to TableB? TableB has a 1:N to TableC or vice versa?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Avoid deleting a record
The best way to control user input is to take over the entire process of record creation/deletion with a dashboard. Basically you are creating another table with just one record where user’s enter…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Multiply a number to get a status
@Sébastien Guillet said: Can I reuse this formula to show me the Chinese sign of a client? Interesting question. You can but just going by year is not accurate as the Chinese New Year typically falls…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Force trigger after update with mass update
@Marisol Echaide said: Cuenta = "A100-2" So "A100-2" is not the record Id. Go to the Cuentas table. Add the Id field to the table view. Find the first instance of a record that has A100-2 in the ID…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Force trigger after update with mass update
@Marisol Echaide said: I tried to replace the first(select()) command with just the record ID and though I didn't get any error on the code, that specific field was not selected. That is interesting.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Force trigger after update with mass update
@Marisol Echaide said: Exactly, that's what I'm trying to recreate with a yes/no switch. Since the action of setting from blank to yes is an update to the record, it serves to activate the trigger.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Incorrectly calculated Week
@Rafael said: The Table 'Control Issues' apparently Look good. Are '1N_Control_Issues' and 'Control Issues' the same table? You need to see why those 6 records in '1N_Control_Issues' are showing up…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Incorrectly calculated Week
@Rafael said: if you see the first image the Date it does not match with the Week. I saw the image, but it looks right to me. You only asked to match Week so since you selected 17 in the dC field…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Incorrectly calculated Week
@Rafael said: On '1N_Control Issues' the weeks are OK and 'Control Issues' the weeks is ok too. What is wrong. I'm not sure what the problem is if you say everything is OK.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Problem with if and else in a loop
Sadly there isn't an exit command. Since you only want to modify Leads records with a Status = 2, you can add that to your select so you can skip the first if/then.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Force trigger after update with mass update
Just to be clear, you want the button to take all newly imported records from Bancos and create a new record in Entrada/Salidas. Are you familiar with the for loop command?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Force a update to trigger all records.
@Marisol Echaide We would be happy to help. Please start a new post and be more descriptive of what you want to achieve.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Generally, you create new tables to track different sets of data. If the only difference between Real 3,4, & 5 is a date then, in my opinion, you would put them in the same table with a field…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael said: One Question. Wouldn't it be easier to create separate tables for each of the Real 3, 4, and 5 ? separate tables? or separate records? generally when you find yourself creating multiple…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Your code doesn’t copy those fields over. You need to add them to the newRec part.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
You have to follow your links to get the correct data now that you have changed your loop2 starting point. if count(loop2.'1N_Control Issues'[Date_ref = fDate]) < 1 then let newRec :…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ", ["Yes", "No"]); if check = "Yes" then for loop2 in (select 'dates by Documents')['Document'] do you changed line 3 to 'dates by…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Wow, I guess I was smarter back then.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
if count(loop2.'1N_Control Issues'[Date_ref = fDate]) < 1 then let newRec := (create 'Control Issues'); newRec.( Date_ref := fDate; 'wbs Documents' := loop2 ) end end end end Line 1:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael wow, looking at it now it looks like it shouldn't work. :) can you send me that DB again?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael is the forum broken? I don't see any line numbers in your or my posts.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
I don't know where this code is supposed to go in your DB. Looking over the code and your DB I have the following questions: let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ",…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Split Records
You can put the code of the button in the Trigger after update in the ITEM field in JOB or in the Trigger on new record for the JOB table (if you move CONDO to Service).
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 70 71 72 73 74 141

Welcome to the Ninox community

Fred

My Posts

Re: SELECT function

Re: SELECT function

Re: SELECT function

Re: Avoid deleting a record

Re: Multiply a number to get a status

Re: Force trigger after update with mass update

Re: Force trigger after update with mass update

Re: Force trigger after update with mass update

Re: Incorrectly calculated Week

Re: Incorrectly calculated Week

Re: Incorrectly calculated Week

Re: Problem with if and else in a loop

Re: Force trigger after update with mass update

Re: Force a update to trigger all records.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Split Records

Overview