Still does not work, sorry. Invalid formula, even when I change to Link to Master.
Thank you so much @geullaideo ! Formatting was indeed the issue.
I ended up using the following formula:
IF(BLANK({Link to Master}),"\""& SUBSTITUTE( ARRAYJOIN( {Link to Master}), ", ", "\", \"" ) & "\"","")
In this formula, Link to Master needs to be substituted with the column linked back to the master records. I have gotten that far. I am working on the next steps now.
1 Like
glad this solution helped you )
@geullaideo In my Airtable base, my table relationship is only one to one, not really one to many. Can you offer an assistance on how I might link the two?
For example, one service request can only be attached to one piece of equipment. However, one piece of equipment can have many service requests. The way my app is set up now, somehow it is creating two Airtable records. One with the fields entered properly, and a second with empty fields, but the proper connection to the master table. I’m not sure what I’ve done wrong.
Thank you.
I appreciate your help.
@mbl79
in my case, I used the typecast = “true” method and it works perfectly using a custom action. here’s a screenshot of my JSON structure as recommended by airtable.
I have a CartID Table & CartItems Table, for every CartID there are many CartItems, so whenever a user adds an item to the cart, I send the CartItem along with the CartID (Linked record) using this typecast method.
Hope it helps.
I cannot for the life of me get this figured out. I can create a record on the service requests table, but cannot get it ‘linked’ back to the master record, even with typecast: true.
With this custom action:
It’s creating TWO records in my table. One that is correctly linked (but with no type or notes), the other that is NOT linked, but with the record information.
AAAARRGHHHHHH! What am I doing wrong?
Ok, I think I know what’s happening here.
Do this in 2 steps instead:
- Create a record without the linked record field
- Update using custom action for the record just created using PATCH and typecast method.
This might work, let me know!
I have been able to ‘log’ the record id, but no matter what I do, I can’t seem to pass the value to the linked field {Link to Master}. Is there something programmatically limiting me to doing so? I am using typecast=true.
Is the create service request a custom action? If yes, this will not provide you the record id on the screen for you to perform update action.
What you need to do instead is:
Step1: Create a record using the adalo’s create function
Step2: Update the record using custom action by taking the record from previous step.
to validate my assumption: can you add a text field on your update screen and try showing the record id, it should most likely be blank and that’s causing the issue.
I am able to pass the record id via text, so that’s what is confusing me. If it can pass the record id from one screen to the next, the data must be available, but it’s like Airtable won’t allow it to be updated.
I solved this issue by using Airtable’s automation function to populate the {Link to Master} from a regular single line text field that is storing the record id from Adalo.
Frustrating that it doesn’t seem to work intuitively or as expected from Adalo’s side though.
Its really confusing, there should be issue in adalo side I think, or it may be in external side! I sometimes review on scripts again and again just to check if lines are correct,
Did anybody figure out a workaround to be able to append a new item to a linked field in airtable (that has a many to many relationship and therefore will have an array of entries)?
お世話になります。
このカスタムアクションの構築方法を写真にてご教授いただけませんでしょうか？
お忙しいところ恐縮ですが、よろしくお願い致します。