Micheal_Ward - profile

Micheal_Ward · Feb 27, 2020

As many would of done, I got the email today regarding scripting. I cant do the webinar due to it being 6am on a Saturday here in Australia but before I spend to much time researching this can scripts work off a submitted form to automatically create...

Micheal_Ward · Jan 15, 2020

Maybe its the new year but I am having a trouble trying to work this out. :slightly_smiling_face: I need a cell to work out 7 postal days from a specified date and add it to a number based on a date column. for example. date column has the date of ...

Micheal_Ward · Nov 12, 2019

I need a simple formula for working out a suburb and it puts out a selected output. eg: if the suburb gorokan or toukley is in the field, the formula puts in KPM1. IF the suburb is hamlyn terrace it puts in KPM2 etc etc This will apply to 5 differen...

Micheal_Ward · Oct 21, 2019

Is it possible to create a form that will enable the data to be put into a record that is already created? eg: We have a campaign that involves many people filling out a form for an auction with property details such as address, agent, office, costs,...

Micheal_Ward · Oct 14, 2019

Another one for the masses. I have 2 columns that calculate days in arrears and rent arrears based on the days in arrears and taking into account a third column of a part payment. A fourth column is a vacate date. these are the formulas for each colu...

Micheal_Ward · Jan 18, 2024

100% this.Using the interface to display public facing info without a paid user is what interfaces are for. If a base can be done that way, why isnt an interface... makes no sense.

Micheal_Ward · Feb 27, 2020

I thought about that but it still has the human interaction. Staff still have things they need to do in this view so will be actively working on the record so adding the link isnt an issue per say, I just wanted to take the human element out of it so...

Micheal_Ward · Feb 27, 2020

Yes please! Im relatively new to all things programming so I just wanted to see what was possible with scripting atm.

Micheal_Ward · Jan 15, 2020

Solved… IF({Date Of Termo issued}, DATEADD(WORKDAY({Date Of Termo issued},7), 14, ‘days’)) now Im happy. :slightly_smiling_face:

Micheal_Ward · Jan 15, 2020

I think I solved some of it… DATEADD(WORKDAY({Date Of Termo issued},7), 14, ‘days’) I had it backwards and tried to work the 7 days first instead of adding the 14 days to the worked out 7 days date. But I now get an error statement if the date of ter...

User Statistics

User Activity

Not a developer but thought I would ask if scripting can do this

A date formula!

Simple If function

Forms and secondary forms

Days in arrears and dollar amount counter type thing!

Re: Show an interface without airtable account.

Re: Not a developer but thought I would ask if scripting can do this

Re: Not a developer but thought I would ask if scripting can do this

Re: A date formula!

Re: A date formula!