Automation - Add Record with formula
I want to run an automation to add a bunch of records to a table once a day, all of which will have in the field Batch Ref: *Tomorrow's Date* & "A bunch of other text". The field type is text, and can...
Forum Discussion
Is there something to type into an automation field that will leave a required formula field alone?
Here is the problem. I have a field in the table that is being populated that is a formula, unique, AND must be filled. It populates itself with the data that comes in to that table. (cipher of text fields)
However, because it must be filled in, it shows up on the Automation as Required to add record. This does not jive, so the Automation is failing and nothing is getting imported.
I have another unique identifier field in this table so the formula one is not really needed, as far as adding information goes, but this formula field is a key field for another table, so it has to be there. (Yes, this is a complicated app)
SO my question is, is there anything I can put in that Automation field so that it just ignores data trying to be added, or anything like that. I am kinda losing it over here about it.
Here is the problem. I have a field in the table that is being populated that is a formula, unique, AND must be filled. It populates itself with the data that comes in to that table. (cipher of text fields)
However, because it must be filled in, it shows up on the Automation as Required to add record. This does not jive, so the Automation is failing and nothing is getting imported.
I have another unique identifier field in this table so the formula one is not really needed, as far as adding information goes, but this formula field is a key field for another table, so it has to be there. (Yes, this is a complicated app)
SO my question is, is there anything I can put in that Automation field so that it just ignores data trying to be added, or anything like that. I am kinda losing it over here about it.