Hello everyone.
How do I auto-fill a date field from Table A, into a form field for Table B?
Iโve tried using Dereferences but itโs not working.
Thank you for any guidance here.
Solved! Go to Solution.
What dereference expressions did you try? In what way didnโt they work? No value? wrong value? Where did you use the expressions?
See also:
What dereference expressions did you try? In what way didnโt they work? No value? wrong value? Where did you use the expressions?
See also:
Hi Steve,
Thank you for replying.
Iโll try to show what Iโm trying to do with screenshots.
The reference for the DOS (date of service) exists in the โScheduleโ table.
When I try to use a reference formula I get a wrong value error.
I donโt understand how to get the date to autofill in the โEncounter Noteโ form โ the form for the โEncounter Notesโ table.
Thank you for your help here!
Please provide a screenshot of the column list for the Encounter Notes table.
Hi Steve,
Here is the screenshot of the column list for the Encounter Notes table.
Thank you in advance.
This doesnโt appear to align with your previous screenshots. Iโm confused.
Hmm, I havenโt made any changes except for one that I describe below.
UPDATE:
The column type for the DOS column was originally Ref.
I then changed it to type Text (as you see in the previous post), and added the formula =[Chart ID].[DOS], and the date is now being autofilled in the Encounter Note form as I want.
So it is now working, and thank you for your help.
Though I donโt understand how that works.
Specifically, how does the column know which table to pull the date from if it is not referenced in the column definition?
[Chart ID].[DOS]
is a dereference expression, in which the Chart ID
column is โdereferencedโ to find a particular row in a particular table, then the DOS column value from that particular row in that particular table is retrieved.
The Chart ID column is of type Ref, which means the value of the Chart ID column โrefersโ to a particular row in a particular table. The particular table is defined in the columnโs configuration:
The particular row is defined by the column value itself: it contains the key column value of a row in that particular table.
[Chart ID].[DOS]
means go to the Source table named by the Chart ID column configuration, find the row in that table that has the same value in its key column as contained in this Chart ID column value, go to the DOS column of that same row and return that columnโs value.
See also:
I have marked this ticket as โSolvedโ.
Very much appreciate your help Steve!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |